Page MenuHomeDevCentral

Members

  • This project does not have any members.
  • View All

Watchers

  • This project does not have any watchers.
  • View All

Details

Description

Need advice about database design or query optimization? Add this tag.

This is a project-as-a-tag.

Recent Activity

Oct 27 2024

dereckson moved T2076: Backup db-B from Backlog to Services to backup on the Backups board.
Oct 27 2024, 01:08 · Backups, DBA, Servers
dereckson added a project to T2076: Backup db-B : Backups.
Oct 27 2024, 00:59 · Backups, DBA, Servers
dereckson moved T2076: Backup db-B from Backlog to Analysis / under discussion on the Servers board.
Oct 27 2024, 00:59 · Backups, DBA, Servers
dereckson moved T2076: Backup db-B from Backlog to Services / Features on the DBA board.
Oct 27 2024, 00:59 · Backups, DBA, Servers
dereckson triaged T2076: Backup db-B as High priority.
Oct 27 2024, 00:58 · Backups, DBA, Servers
dereckson created T2076: Backup db-B .
Oct 27 2024, 00:58 · Backups, DBA, Servers

Oct 26 2024

dereckson updated the language for P367 bak-mysql.sh from autodetect to bash.
Oct 26 2024, 23:44 · DBA, Servers
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.
Oct 26 2024, 21:59 · good-first-issue, DBA, Servers
dereckson added a project to T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql: good-first-issue.
Oct 26 2024, 21:58 · good-first-issue, DBA, Servers
dereckson triaged T2074: Mount mysql-innodb-data and mysql-innodb-logs ZFS datasets outside /var/db/mysql as High priority.
Oct 26 2024, 21:58 · good-first-issue, DBA, Servers

Jan 15 2024

dereckson added a revision to T1888: Add XML support on db-A PostgreSQL: D3290: Ensure PostgreSQL port is still up-to-date on FreeBSD.
Jan 15 2024, 21:37 · upstream, DBA, Servers
dereckson closed T1888: Add XML support on db-A PostgreSQL as Resolved.
Jan 15 2024, 00:21 · upstream, DBA, Servers
dereckson added a revision to T1888: Add XML support on db-A PostgreSQL: D3287: Fix PostgreSQL 15 build instructions.
Jan 15 2024, 00:19 · upstream, DBA, Servers
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 15 2024, 00:16 · upstream, DBA, Servers

Jan 14 2024

dereckson added a parent task for T1888: Add XML support on db-A PostgreSQL: T1943: Orbeon Forms trigger an error after application is submit.
Jan 14 2024, 23:19 · upstream, DBA, Servers
dereckson reopened T1888: Add XML support on db-A PostgreSQL as "Open".

When upgraded to FreeBSD 14, we lost this.

Jan 14 2024, 23:18 · upstream, DBA, Servers

Jun 6 2023

inidal added a revision to T1847: Set up PostgreSQL database: D3182: Implement basic MVC architecture.
Jun 6 2023, 05:53 · DBA, ServPulse
inidal added a revision to T1842: Design DB schema: D3182: Implement basic MVC architecture.
Jun 6 2023, 05:53 · DBA, ServPulse

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?

May 31 2023, 21:14 · DBA, ServPulse
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?

May 31 2023, 21:13 · DBA, ServPulse
inidal 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?

May 31 2023, 21:02 · DBA, ServPulse
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?

May 31 2023, 20:40 · DBA, ServPulse
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 31 2023, 19:44 · DBA, ServPulse

May 25 2023

dereckson added a revision to T1888: Add XML support on db-A PostgreSQL: D3132: Handle the odd case no package is needed in roles/dbserver-pgsql/server.
May 25 2023, 15:42 · upstream, DBA, Servers
dereckson closed T1888: Add XML support on db-A PostgreSQL as Resolved by committing rOPSe79d77e83a85: Build PostgreSQL with XML support on FreeBSD.
May 25 2023, 04:54 · upstream, DBA, Servers
dereckson added a revision to T1888: Add XML support on db-A PostgreSQL: D3130: Build PostgreSQL with XML support on FreeBSD.
May 25 2023, 04:52 · upstream, DBA, Servers
dereckson added a comment to T1888: Add XML support on db-A PostgreSQL.

Packages required to build it ourselves:

May 25 2023, 04:35 · upstream, DBA, Servers
dereckson added a project to T1888: Add XML support on db-A PostgreSQL: upstream.

upstream https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=269115

May 25 2023, 04:26 · upstream, DBA, Servers
dereckson triaged T1878: Allow to run queries for reporting as Wishlist priority.
May 25 2023, 04:23 · Monitoring and reporting, security, DBA, Servers
dereckson moved T1878: Allow to run queries for reporting from Backlog to Services / Features on the DBA board.
May 25 2023, 04:23 · Monitoring and reporting, security, DBA, Servers
dereckson moved T1888: Add XML support on db-A PostgreSQL from Backlog to Servers on the DBA board.
May 25 2023, 04:21 · upstream, DBA, Servers
dereckson triaged T1888: Add XML support on db-A PostgreSQL as High priority.
May 25 2023, 04:21 · upstream, DBA, Servers

May 20 2023

dereckson updated the task description for T1878: Allow to run queries for reporting.
May 20 2023, 15:45 · Monitoring and reporting, security, DBA, Servers
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 20 2023, 15:43 · Monitoring and reporting, security, DBA, Servers
dereckson created T1878: Allow to run queries for reporting.
May 20 2023, 15:42 · Monitoring and reporting, security, DBA, Servers

May 6 2023

dereckson set the image for DBA to F2214901: profile.
May 6 2023, 13:10

May 2 2023

inidal triaged T1847: Set up PostgreSQL database as High priority.
May 2 2023, 08:59 · DBA, ServPulse
inidal created T1847: Set up PostgreSQL database.
May 2 2023, 08:33 · DBA, ServPulse

May 1 2023

dereckson set the color for DBA to Orange.
May 1 2023, 21:39
dereckson moved T1842: Design DB schema from Backlog to Design on the DBA board.
May 1 2023, 21:30 · DBA, ServPulse
dereckson added a project to T1842: Design DB schema: DBA.
May 1 2023, 21:30 · DBA, ServPulse
dereckson created DBA.
May 1 2023, 21:28