---
title: "#databases articles | Hashnode"
description: "Explore 7,104 articles tagged #databases on Hashnode. Tutorials, guides, and how-tos from the community."
url: "https://hashnode.com/tag/databases"
---

Tag

# #databases

7,104 posts · 2,214 followers

[Cream DB](https://hashnode.com/@creamdb) · [2h ago](https://hashnode.com/posts/mariadb-practical-guide/6afa8dd8980aa6bcd82a3f7d)

### [MariaDB: A Practical Guide to the Fork That Grew Up](https://blog.creamdb.com/mariadb-practical-guide?utm_source=hashnode&utm_medium=feed)

How MariaDB differs from MySQL today, the features worth using, and how to run it without surprises

10 min read · [blog.creamdb.com](https://blog.creamdb.com/mariadb-practical-guide?utm_source=hashnode&utm_medium=feed)

[Min SiThu](https://hashnode.com/@itsmeminsithu) · [6h ago](https://hashnode.com/posts/what-is-a-database-transaction-the-promise-behind-every-payment/6afa60eaf3e0b7160c616051)

### [What Is a Database Transaction? The Promise Behind Every Payment](https://itsmeminsithu.hashnode.dev/what-is-a-database-transaction-the-promise-behind-every-payment?utm_source=hashnode&utm_medium=feed)

Why your money never vanishes halfway between two accounts

6 min read · [itsmeminsithu.hashnode.dev](https://itsmeminsithu.hashnode.dev/what-is-a-database-transaction-the-promise-behind-every-payment?utm_source=hashnode&utm_medium=feed)

[Prasad Kukkala](https://hashnode.com/@techiesjournal) · [1d ago](https://hashnode.com/posts/postgresql-and-pgvector-when-should-ai-applications-use-a-separate-vector-database/6af95083ea9a9f6cccea0e80)

### [PostgreSQL and pgvector: When Should AI Applications Use a Separate Vector Database?](https://techies-journal.hashnode.dev/postgresql-and-pgvector-when-should-ai-applications-use-a-separate-vector-database?utm_source=hashnode&utm_medium=feed)

An AI application can keep business records, embeddings and searchable documents in PostgreSQL, or introduce a dedicated vector system. The right decision depends on retrieval quality, access controls

11 min read · [techies-journal.hashnode.dev](https://techies-journal.hashnode.dev/postgresql-and-pgvector-when-should-ai-applications-use-a-separate-vector-database?utm_source=hashnode&utm_medium=feed)

[Abdus Salam](https://hashnode.com/@aheadkit) · [1d ago](https://hashnode.com/posts/how-a-22-year-old-postgresql-type-confusion-became-remote-code-execution/6af8fcd39b55502027185ac7)

### [How a 22-Year-Old PostgreSQL Type Confusion Became Remote Code Execution](https://aheadkit.hashnode.dev/how-a-22-year-old-postgresql-type-confusion-became-remote-code-execution?utm_source=hashnode&utm_medium=feed)

Four SQL statements, a login with no special privileges, and a server process that dies with signal 11. That is the entry point to CVE-2026-6460, the PostgreSQL flaw security researcher Mehmet Ince wr

10 min read · [aheadkit.hashnode.dev](https://aheadkit.hashnode.dev/how-a-22-year-old-postgresql-type-confusion-became-remote-code-execution?utm_source=hashnode&utm_medium=feed)

[abduljabbar sani](https://hashnode.com/@abdoull) · [21h ago](https://hashnode.com/posts/how-i-built-a-58-000-line-zero-row-database-intelligence-platform-and-why-i-m-selling-it-for-4-800/6af98a0e1d5222494f0aae27)

### [How I Built a 58,000-Line Zero-Row Database Intelligence Platform (And Why I’m Selling It for $4,800)](https://solunex-ssdo.hashnode.dev/how-i-built-a-58-000-line-zero-row-database-intelligence-platform-and-why-i-m-selling-it-for-4-800?utm_source=hashnode&utm_medium=feed)

8 native SQL profilers, 2,060+ tests, and zero data rows read — passing this complete turnkey platform to an operator or dev agency.

4 min read · [solunex-ssdo.hashnode.dev](https://solunex-ssdo.hashnode.dev/how-i-built-a-58-000-line-zero-row-database-intelligence-platform-and-why-i-m-selling-it-for-4-800?utm_source=hashnode&utm_medium=feed)

[ilshaad](https://hashnode.com/@ilshadyx) · [21h ago](https://hashnode.com/posts/how-to-sync-billing-data-to-prisma-postgres-stripe-quickbooks-xero-paddle/6af9847530cfe2216b559507)

### [How to Sync Billing Data to Prisma Postgres (Stripe, QuickBooks, Xero & Paddle)](https://codeless-sync.hashnode.dev/how-to-sync-billing-data-to-prisma-postgres-stripe-quickbooks-xero-paddle?utm_source=hashnode&utm_medium=feed)

Sync Stripe, QuickBooks, Xero or Paddle into Prisma Postgres. Which connection string to use, how a batched sync counts operations, and what it costs.

13 min read · [codeless-sync.hashnode.dev](https://codeless-sync.hashnode.dev/how-to-sync-billing-data-to-prisma-postgres-stripe-quickbooks-xero-paddle?utm_source=hashnode&utm_medium=feed)

[Cream DB](https://hashnode.com/@creamdb) · [1d ago](https://hashnode.com/posts/mysql-practical-guide/6af93c65359bb63d4c7c4e3d)

### [MySQL: A Practical Guide to the Web's Workhorse Database](https://blog.creamdb.com/mysql-practical-guide?utm_source=hashnode&utm_medium=feed)

What MySQL does well, where another database fits better, and the five settings and habits that keep it out of trouble

9 min read · [blog.creamdb.com](https://blog.creamdb.com/mysql-practical-guide?utm_source=hashnode&utm_medium=feed)

[Bigdomainhost](https://hashnode.com/@bigdomainhost) · [1d ago](https://hashnode.com/posts/dedicated-server-or-vds-a-practical-way-to-decide-for-databases-game-servers-and-ci/6af8a3791c93d0267438f6f6)

### [Dedicated server or VDS? A practical way to decide for databases, game servers and CI](https://bigdomainhost.hashnode.dev/dedicated-server-or-vds-a-practical-way-to-decide-for-databases-game-servers-and-ci?utm_source=hashnode&utm_medium=feed)

If your problem is CPU time that wobbles (latency spikes, uneven build times, a game server that lags when nothing on your side changed), a VDS with whole physical cores pinned to you usually fixes it

12 min read · [bigdomainhost.hashnode.dev](https://bigdomainhost.hashnode.dev/dedicated-server-or-vds-a-practical-way-to-decide-for-databases-game-servers-and-ci?utm_source=hashnode&utm_medium=feed)

[SAI PRANEETH BHATTU](https://hashnode.com/@saipraneethbhattu) · [1d ago](https://hashnode.com/posts/database-design-fundamentals-data-modeling-sql-vs-nosql-and-indexing/6af8d64cf97ae75f9add09b7)

### [Database Design Fundamentals: Data Modeling, SQL vs. NoSQL, and Indexing](https://saipraneethbhattu.hashnode.dev/database-design-fundamentals-data-modeling-sql-vs-nosql-and-indexing?utm_source=hashnode&utm_medium=feed)

Every application generates data. Whether users create accounts, upload photos, like posts, or leave comments, we need a reliable way to store and retrieve that information. But before choosing a database such as PostgreSQL or MongoDB, we need to understand what data our application stores and how users interact with it. This process is called data modeling. It involves identifying the information we need, organizing it into logical entities, and defining the relationships between them. Let's explore how to design this database layer using a photo-sharing application as our example.

7 min read · [saipraneethbhattu.hashnode.dev](https://saipraneethbhattu.hashnode.dev/database-design-fundamentals-data-modeling-sql-vs-nosql-and-indexing?utm_source=hashnode&utm_medium=feed)

[Uptime Architect](https://hashnode.com/@uptimearchitect) · [1d ago](https://hashnode.com/posts/ora-03113-after-the-connection-sat-idle-the-firewall-forgot-it/6af878095d514f5227f9ebb5)

### [ORA-03113 After the Connection Sat Idle: The Firewall Forgot It](https://uptimearchitect.hashnode.dev/ora-03113-after-the-connection-sat-idle-the-firewall-forgot-it?utm_source=hashnode&utm_medium=feed)

Why idle pooled Oracle connections fail with ORA-03113 or ORA-03135 behind a firewall or load balancer, and the SQLNET.EXPIRE\_TIME fix.

14 min read · [uptimearchitect.hashnode.dev](https://uptimearchitect.hashnode.dev/ora-03113-after-the-connection-sat-idle-the-firewall-forgot-it?utm_source=hashnode&utm_medium=feed)
