Need advice about database design or query optimization? Add this tag.
This is a project-as-a-tag.
Details
Details
Description
Sun, Oct 27
Sun, Oct 27
dereckson moved T2076: Backup db-B from Backlog to Analysis / under discussion on the Servers board.
dereckson created T2076: Backup db-B .
Sat, Oct 26
Sat, Oct 26
dereckson moved T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql from Backlog to Ops on the good-first-issue board.
dereckson triaged T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql as High priority.
Jan 15 2024
Jan 15 2024
dereckson added a revision to T1888: Add XML support on db-A PostgreSQL: D3287: Fix PostgreSQL 15 build instructions.
dereckson added a comment to T1888: Add XML support on db-A PostgreSQL.
I've added documentation to https://agora.nasqueron.org/Operations_grimoire/FreeBSD#PostgreSQL without real conviction.
Jan 14 2024
Jan 14 2024
dereckson reopened T1888: Add XML support on db-A PostgreSQL as "Open".
When upgraded to FreeBSD 14, we lost this.
Jun 6 2023
Jun 6 2023
inidal added a revision to T1847: Set up PostgreSQL database: D3182: Implement basic MVC architecture.
May 31 2023
May 31 2023
dereckson added a comment to T1842: Design DB schema.
What if we plan a brainstorming session where we put cards on a wall, one card per feature we'd like to see on the app?
dereckson added a comment to T1842: Design DB schema.
Not sure each service has an IP, or only an IP. For those we do, what we do with the IP?
dereckson added a comment to T1842: Design DB schema.
Can you give an example of what you wish to store as information and how you wish to use it?
inidal added a comment to T1842: Design DB schema.
@dereckson hey, we forgot about id addresses, so do you think it would be wise to simply add a new column in the service table?
May 25 2023
May 25 2023
dereckson closed T1888: Add XML support on db-A PostgreSQL as Resolved by committing rOPSe79d77e83a85: Build PostgreSQL with XML support on FreeBSD.
dereckson added a comment to T1888: Add XML support on db-A PostgreSQL.
Packages required to build it ourselves:
dereckson moved T1878: Allow to run queries for reporting from Backlog to Services / Features on the DBA board.
May 20 2023
May 20 2023
dereckson updated the task description for T1878: Allow to run queries for reporting.
dereckson added a comment to T1878: Allow to run queries for reporting.
As a minimum, to have somewhere (a reports repository?) where we can write those report queries could already be useful, so we don't lose them.
May 6 2023
May 6 2023
May 2 2023
May 2 2023
May 1 2023
May 1 2023