Jamey Bartondbajamey.hashnode.dev·Apr 29, 2024JOINs in PostgreSQL: Types with 9 ExamplesPostgreSQL is an open-source relational database management system (RDBMS) known for its robust features, reliability, and scalability. It is used to manage and store data, both for small-scale applications and for large enterprise systems. PostgreSQ...DiscussPostgreSQL
Sai SrirampurforPeerDB Blogblog.peerdb.io·Apr 25, 2024How can we make pg_dump and pg_restore 5 times faster?pg_dump and pg_restore are reliable tools for backing up and restoring Postgres databases. They're essential for database migrations, disaster recovery and so on. They offer precise control over object selection for backup/restore, dump format option...Discuss·5.5K readsPostgreSQL
Daniel Lopesdanieljalopes.hashnode.dev·Apr 21, 2024Flyway for Database VersioningIntroduction This article intends to be an introduction to how to automate database migrations for 3 different environments: development, testing and production. Each one runing on its own Docker Compose virtual machine. In order to see the implement...DiscussDocker compose
Joseph Caudlejosephcaudle.hashnode.dev·Apr 17, 2024PostGIS and Heroku Postgres… Location, Location, Location!I’ve lost too much time fiddling around with configurations and services just to spin up a compute instance in AWS. Sometimes, I just need a production-ready environment to play around with to test out applications and ideas. With Heroku, I can get t...DiscussHeroku
Ritobroto Sethrito.hashnode.dev·Apr 16, 2024FeaturedSyncing Qdrant with Postgres Using Airbyte to Build RAG Applications over SQL DataOverview One of the major hurdles in building robust RAG applications is keeping the Vector Store consistently updated with the latest information. This is crucial because RAG models rely on this store to retrieve relevant context for generating accu...Discuss·23 likes·101 readsairbyte
Sai SrirampurforPeerDB Blogblog.peerdb.io·Apr 11, 2024PeerDB raises $3.6 million seed funding to revolutionize data movement for PostgreSQLPeerDB offers a fast and cost-effective way to move data from PostgreSQL to data warehouses, such as Snowflake, and to queues like Kafka. This enables businesses to have real-time and reliable access to data, which is of utmost importance in this AI ...Discuss·2.2K readsPostgreSQL
Michael Krutikovmkrutikov.hashnode.dev·Apr 10, 2024Migrating my project from MySQL to Postgres because of one cool featureIn previous posts, I wrote about my pet project - a URL shortener written in three programming languages. The prototype works well, but there is one issue: if many clients try to add new URLs concurrently, they can get the same short URL, and that's ...DiscussDatabases
Kevin BijuforPeerDB Blogblog.peerdb.io·Apr 1, 2024Exploring versions of the Postgres logical replication protocolIntroduction Logical Replication is one of the many ways a Postgres database can replicate data to other Postgres database (a.k.a standby). Logical replication directly reads from the write-ahead log (WAL), recording every database change, avoiding t...Discuss·1 like·4.7K readsPostgreSQL
Sudhanva Nadigersudhanva-nadiger-blogs.hashnode.dev·Mar 22, 2024Decoding Drizzle ORM 💧.In the world of software development, efficient data management is one of the important aspects. As applications grow in complexity and scale, so do the challenges associated with interacting with databases. Writing raw SQL queries is not only hard b...Discuss·1 like·39 readsDrizzleORM
Jamey Bartondbajamey.hashnode.dev·Mar 22, 2024PostgreSQL vs SQL Server: What Are the Differences?In today’s business landscape, effective management and storage of data are more crucial than ever. As a result, selecting the appropriate database management system for each particular project can be complicated. There is no universal solution for a...DiscussDatabases