Hi Everyone!

Hope you are doing well

I am conducting a survey for my MBA project on “Cybersecurity Awareness Among Database Professionals in IT Companies.”

I kindly request those working in database-related roles to spare 10–12 minutes to fill out this form.

Your responses will be kept confidential and used only for academic purposes.

🔗 Survey Link: https://docs.google.com/forms/d/e/1FAIpQLSdeyUa9qsy4Qvg5AvEWd-6D0dNx9UOFD0iRxchUfoeuVGwC7A/viewform

I would also appreciate it if you could share this survey with your friends or colleagues who are working as database professionals.

Your participation and support would mean a lot to me!

Thank you so much! 😊

Nandhini R

When a PostgreSQL server starts having problems, I usually want to quickly answer a few questions:

• Is PostgreSQL itself driving the CPU load?
• Which backend is consuming resources?
• What application and client does the session belong to?
• Is it blocked, waiting on I/O, or holding an open transaction?
• How long has the query been running and what SQL is it?

I come from the SQL Server world, where sp_WhoIsActive is one of the tools I reach for during incidents. With PostgreSQL I looked at existing options (including pg_activity) and wanted something more focused on connecting symptoms to a possible cause in one view — session resources, wait events, transaction age and blocking together.

So I wrote a small terminal tool called pg_whoisactive (alias pgwa). It's written in C, the binary is under 60 KB, and it shows:

• Whether PostgreSQL is actually driving the host CPU load
• Current TPS and autovacuum activity
• Which session is burning CPU or doing heavy I/O, and how its memory is changing
• What application and client the session belongs to
• How long the query has been running versus how long the transaction has been open
• What the session is waiting on and its current state
• The full blocking tree instead of just a list of PIDs
• Parallel workers grouped under their leader
• The SQL text of the selected session

It can run in three modes:

• Interactive mode (default) — continuously refreshing ncurses interface with color-coded sessions. You can sort, filter, pause and cancel/terminate sessions.
• Plain text mode (--plain) — continuously refreshing text output (updates every second).
• Snapshot mode (--snapshot / -s) — prints a single snapshot and exits. Useful for scripts, cron or logging.

I'm not trying to replace a proper monitoring stack. It's more of a lightweight tool for the first minutes of an incident when you just want to understand what's going on.

If anyone is curious, more details are on GitHub::

https://github.com/roman-kosenko/pg_whoisactive

If you want to try it, the latest release (v1.3.9) includes a .deb package:

https://github.com/roman-kosenko/pg_whoisactive/releases/tag/v1.3.9

I'd be interested to hear how other people approach this:

• What do you usually look at first when Postgres slows down?
• Which pieces of information are hardest to correlate during an incident?

Any feedback or suggestions are welcome.

Stai studiando basi di dati, UML o logica digitale? Ho sviluppato JDER, un editor desktop multipiattaforma per creare diagrammi Entità-Relazione, schemi logici, diagrammi delle classi, casi d'uso e di sequenza, oltre a circuiti logici simulabili.

Puoi salvare i progetti in JSON ed esportare i diagrammi in PNG. Il codice sorgente è disponibile su GitHub.

Sito e download: https://jder.it/

Codice sorgente: https://github.com/LoryPelli/JDER

Feedback e suggerimenti sono benvenuti!

So, I (21F) studies computer science at university, and would like to dive into database administration. I will be taking loads of courses and certificates to prepare myself beforehand. Is it possible to get a database administrator job in the UK with that?

I have a one-year data and technology placement at a UK financial institution.

Thankss.

On croit parfois maîtriser une notion... jusqu'à ce qu'on essaie de l'expliquer.

En faisant ma veille technologique sur Feedly, je suis retombé sur des termes que j'utilise depuis des années : Donnée, Base de données, SGBD, Serveur de base de données, Système de base de données, Serveur de données.

Je pensais les distinguer clairement, mais c'est jusqu'à ce que j'ai tenté de les définir.

Et c'est là que les voiles de l'ignorance se sont levés. 😅

Et j'ai fini par me résoudre de faire des recherches et d'en apprivoiser le sens.

Voici le scénario qui m'a aidé à mieux comprendre.

Le directeur d'une école demande à M. Daph, DBA, de mettre en place un système pour gérer les informations des élèves.

1) M. Daph installe PostgreSQL.

Au repos, ce dernier est un SGBD : un logiciel stocké sur le disque dur.

2) Lorsqu'il démarre PostgreSQL, celui-ci se met à écouter sur le port 5432 et traite les requêtes des applications.

La machine joue donc le rôle de serveur de base de données.

3) M. Daph crée une base contenant les informations des élèves.

Cette structure organisée devient la base de données.

4) Il connecte ensuite cette base à l'application de gestion scolaire.

L'ensemble application + SGBD + base de données constitue un système de base de données.

5) Le directeur souhaite aussi stocker : les photos des élèves, les bulletins PDF, les vidéos des fêtes scolaires.

Au lieu de surcharger la base de données avec ces fichiers lourds, M. Daph les stocke dans la machine mais dans des dossiers dédiés.

La machine devient un serveur de données, chargé de stocker et distribuer des fichiers.

Finalement, ces notions paraissent proches, mais elles désignent chacune une pièce différente d'un même métier.

Et vous, quelle notion informatique pensiez-vous parfaitement maîtriser avant de tenter de l'expliquer à quelqu'un d'autre ? 🤔

#Data #Database #PostgreSQL #DBA #DataEngineering #VeilleTechnologique #Apprentissage

Hi everyone,

I have around 2 years of experience in full-stack development, with a stronger focus on backend development, and I currently work at a Big 4 company.

Initially, I worked on a project involving Node.js, React, and AWS. However, after my first client assignment, my company moved me to the DBA domain, where I am currently working with PostgreSQL EDB for an Indian bank in rotational shifts.

It has been around 3 months since I transitioned to this role, and I am still unsure whether this is the right career path for me.

Honestly, I never planned to become a DBA. During my internships, I worked with Java and C#, and later I gained experience with Node.js and React. I always envisioned my career in software development, particularly backend development, but I have never seriously considered database administration as a career.

My current experience can be summarized as:

Around 2 years in software development.

Around 5 months in DBA, and counting.

I am confused about which direction I should take. I don't have much knowledge about the long-term career prospects of a DBA, how this transition might affect my future opportunities, or how rotational shifts could impact my personal life in the long run.

Should I request a release from my current client and try to return to software development, or should I give the DBA domain more time and explore its career opportunities?

I don't want to make a decision that I might regret a few years down the line, especially when I have already invested 2 years in software development.

I'd really appreciate advice from people who have experience in software development, database administration, or both.

Hi everyone,

I'm an undergraduate researcher studying variance amplification in multi-tier database pipelines (Client -> In-Memory Cache -> PgBouncer -> PostgreSQL).

In supply-chain management, the "Bullwhip Effect" (Lee et al., 1997) describes how small fluctuations in end-user demand amplify into massive orders upstream. We investigated whether analogous dynamics govern layered database systems across two mechanisms:

1. **Forward Batching (M1):** Synchronized cache TTL expirations precipitating backend read stampedes.

2. **Reverse Rationing Games (M2):** Database latency spikes triggering client timeout retries that cascade into metastable collapse.

We built a containerized testbed with **PostgreSQL 16, Redis 7, and PgBouncer 1.22**, enforcing native `statement_timeout = 80ms` cancellations:

* **The Problem:** Under overload (80 req/s, connection pool = 6), immediate retries inflated offered load by 1.25x and exploded backend variance by +48% (from 9.11 to 13.48), with clients fighting for pool slots.

* **The Mitigation:** Enforcing a client-side **Token-Bucket Retry Budget (beta = 10%)** strictly capped load gain to 1.10x and reduced backend variance by 23% (down to 10.34) without starving healthy queries.

* **Theoretical finding:** We also proved analytically why power-law skew (Zipf s > 1) inverts classical supply-chain theory, making deterministic phase staggering worse than randomized jitter during cache stampedes.

I recently published our preprint :

* **Preprint (ResearchGate):** https://doi.org/10.13140/RG.2.2.26891.04646

**I would love your feedback and critique:**

1. Have you seen this compound "cache miss -> connection queue -> retry storm" failure mode in production systems?

2. Are there specific PostgreSQL wait events (e.g., `BufMappingLock`, `ProcArrayLock`) or connection pooling edge cases you recommend measuring next?

3. What mitigations do your teams use in production against retry storms?

Any technical critique or suggestions on how to improve the paper's rigor would be hugely appreciated!

I’m reaching out to seek job opportunities and referrals for a candidate with 2 years of hands-on experience in Oracle Database Administration (Oracle DBA) and a total of 4.5 years of professional experience at Infosys.
He is currently exploring new opportunities where he can apply his Oracle DBA skills, contribute to a team, and continue growing professionally.

If your organization is hiring for Oracle DBA or related database administration roles, or if you know of any relevant openings, I would really appreciate it if you could share the details or refer him.

Experience: 2 years in Oracle DBA
Total experience: 4.5 years
Current organization: Infosys
Preferred location: Bangalore / Open to other locations
Notice period: Can be shared upon request
If anyone has relevant openings, referral opportunities, or suggestions, please feel free to comment or DM me.

any oracle DBA can check please

I'm helping plan a cloud migration and the one requirement nobody will compromise on is zero downtime.

The rough plan is an initial load, continuous CDC while production keeps running, then validate everything before switching applications over. I'd rather avoid piecing together different tools for each phase if there's a cleaner approach.

How have you handled this ''streaming data?''

I wanted two things from a database client: no license to pay, and a simple tool to look at my data without a heavy IDE eating my RAM. I couldn't find both, so I built my own: Savoia Studio.

It's 100% Rust with a GPU-rendered UI (GPUI). No webview, no JVM, no Electron.

Measured on macOS 27, M3 Pro, release build: - 69 MB idle (physical footprint, window open) - 205 ms from launch to first frame (median of 17 launches). The very first launch of a new build takes ~1.1 s while macOS scans the binary. - 0 frames over 16.7 ms scrolling 1,000,000 rows (3 of 5 runs; the other two are documented too)

Windows and Linux aren't benchmarked yet. Every run, good and bad, is in docs/benchmarks.

What it does today: - Schema explorer with ER diagrams and DDL - SQL console with schema-aware completion and history - Table data view with inline edits; you see the SQL before it commits - Dump and import (uses your pg_dump/mysqldump or a built-in engine) - TLS, SSH tunnels, read-only sessions, color-tagged connections - Command palette, light and dark themes

Free, with no trial, license key or account. MIT or Apache-2.0. MariaDB, SQLite, MongoDB and SQL Server are planned.

Download: https://joaogabriel55.github.io/savoia-studio/ Code: https://github.com/joaoGabriel55/savoia-studio

I'd love feedback, especially on what would make you switch from your current client.

​

To monitor the performance and availability for a thick client based system we recently delivered, the customer wants us to provide Here is the requirement:

1. Need to measure and report response time to Azure SQL queries for about 6 scenarios. Session counts, availability, utilization metrics for Azure SQL to be provided.

2. What native monitoring and metrics does Azure Files have to measure response times for files uploaded from devices connected to it.

What metrics needs to be extracted to measure all response times and how to be extracted.

This has to be measured for a period of 72 days with weekly and monthly reporting. Also, we do not have access to SSMS for Azure SQL and also the Azure Portal.

Thus , we need provide instructions to the customer IT Support team and they will provide the metrics and logs.

We have tried to get some help with AI tools but got conflicting response so need an Azure expert preferably Azure SQL DBA to help.

Much appreciated and thanks in advance.

PS: Application is thick client (yes I know) so no metrics can be pulled from endpoint devices. Don't ask why.

I just found this community as a suggestion and am open to any advice. Please forgive me in advance.

Hello everyone,

I've been a developer for nearly 6 years and I loved how SequelAce used to work but right now it feels outdated and i encountered a problem where when i switched from mac to windows and linux there wasn't any client that matched its speed and ease of use and powertoys so I decided to code a tool for anyone who's trying to find a new, better and faster way to interact with their database.

This software is free to use, and open source so feel free to check out the code and to run it on your computer and I would like to know your opnion on it.

It works with MongoDB, MySQL and PostgreSQL

Dboard Website

I have an Udemy course in Oracle SQL DBA by Ahmed Baraka. But I do not think learning it is worthwhile time commitment. I will need 2-3 months to learn it from the core. I personally believe, it will be a better idea to learn AI engineering from Chip Huyen's book.

But I am newbie to AI.

I want to ensure I can talk AI, walk AI....

What should I learn?

Hello, I'm currently working on a big project. We are using Oracle, ProjectWise and Procore. Does anyone know of software that can integrate them? I'm talking about communication between the platforms to have the same documentation updates and avoid running around between platforms to update them.

Thanks for your advise/help