PostgreSQL
Firebird
| PostgreSQL | Firebird | |
|---|---|---|
| 466 | - | |
| 16,363 | 12 | |
| 1.5% | - | |
| 10.0 | 2.6 | |
| 7 days ago | about 1 year ago | |
| C | C++ | |
| GNU General Public License v3.0 or later | - |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
PostgreSQL
-
ClickHouse: The Key to Faster Insights
While both Postgres and ClickHouse serve different purposes, the key distinction lies in how they handle replication and sharding. Postgres is primarily designed for transactional workloads (OLTP), where data consistency and durability are prioritized. On the other hand, ClickHouse is tailored for analytical workloads (OLAP), and optimized for high-speed querying and large-scale data analysis.
-
PostgreSQL Performance Tuning: The Power of work_mem
For your information, the tuplesort.c module flags when the Sort algorithm will use disk by setting the state to SORTEDONTAPE at this line. Disk interactions is handled by the logtape.c module.
-
How I Solved Common Prisma ORM Errors: Debugging Tips and Best Practices
This error happens when using a relational database, like PostgreSQL (one of the most popular, and advanced open-source SQL databases on the market).
-
How to Set Up Next.js 15 for Production in 2024
This tutorial is going to use Postgres for its database because it is well battle-tested, but you're going to use the Prisma ORM to abstract away the database layer. This gives you the flexibility to use a variety of databases, and simplifies the API that you use to interact with it.
-
PSA: SQLite does not do checksums
Yes, it's a balancing act. I think it's better to have safer defaults here, not prioritizing extra performance. People who are concerned with performance to the degree where checksums would matter need to consult configuration anyway (in many aspects, not only this one) and can disable this specific thing easily.
For the reference, change is in https://github.com/postgres/postgres/commit/04bec894a04c (so should land in PostgreSQL 18 in a year, unless it will get reverted for some reason).
-
How to self-host Postgres Database on Linux
PostgreSQL, commonly referred to as Postgres, is a powerful, open-source relational database management system (RDBMS) known for its robustness, extensibility, and standards compliance. It was introduced in 1986 by Michael Stonebraker and his team at the University of California, Berkeley, as part of the POSTGRES project, which aimed to address some of the limitations of existing database systems at the time.
-
100+ Must-Have Web Development Resources
PostgreSQL: An open-source object-relational database management system, used early on by Uber.
-
Las herramientas imprescindibles para desarrolladores Full Stack en 2024
PostgreSQL
-
8 Backend Tools to Become a Better Developer
Link: https://www.postgresql.org/
-
Simple Next.js Magic Link JWT Authentication with Prisma, PostgreSQL, and Resend
When building web applications, authentication is almost always a core requirement. I needed something simple and secure that would let me get started quickly on new projects without over-complicating the setup. My goal was to have a solution that's easy to implement, handles email verification out of the box, and just works. In this post, I'm sharing how to build a straightforward magic link authentication system using Next.js, Auth.js, Prisma, PostgreSQL, and Resend. It's a powerful yet simple solution that accomplishes exactly what I needed, and I hope it'll be useful for your projects too.
Firebird
We haven't tracked posts mentioning Firebird yet.
Tracking mentions began in Dec 2020.
What are some alternatives?
psycopg2 - PostgreSQL database adapter for the Python programming language
MariaDB - MariaDB server is a community developed fork of MySQL server. Started by core members of the original MySQL team, MariaDB actively works with outside developers to deliver the most featureful, stable, and sanely licensed open SQL server in the industry.
ClickHouse - ClickHouse® is a real-time analytics DBMS
phpMyAdmin - A web interface for MySQL and MariaDB
MySQL - MySQL Server, the world's most popular open source database, and MySQL Cluster, a real-time, open source transactional database.
Adminer - Database management in a single PHP file
SQLite - Unofficial git mirror of SQLite sources (see link for build instructions)
debezium - Change data capture for a variety of databases. Please log issues at https://issues.redhat.com/browse/DBZ.
SQLite - Official Git mirror of the SQLite source tree