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·75 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·1.8K 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
Sai SrirampurforPeerDB 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.5K 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·36 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
Sai SrirampurforPeerDB Blogblog.peerdb.io·Mar 15, 2024Enterprise-grade Replication from Postgres to Azure Event HubsAt PeerDB, we are building a fast and a cost-effective way to replicate data from Postgres to Data Warehouses and Queues. Today we are releasing our Azure Event Hubs connector. With this, you get a fast, simple, and reliable way to Change Data Captur...Discuss·359 readsPostgreSQL
Natasha Sharmanssharma.hashnode.dev·Mar 13, 2024PostgreSQL + Python for Beginners 🐘🐍 (Part 2)If you've ever worked with older database systems, you're likely familiar with .dbf files. These files were widely used in dBase, FoxPro, and other database software before the rise of more modern systems like PostgreSQL. But what if your current pro...Discuss·1 likePythonPython
Shiv IyerProshiviyer.hashnode.dev·Mar 9, 2024Implementing Dynamic PIVOT Tables in PostgreSQL with PL/pgSQLDynamically pivoting tables in PostgreSQL involves transforming rows into columns dynamically, typically because the number of columns can change based on the data. Unlike some other RDBMS like SQL Server, PostgreSQL doesn't have a built-in PIVOT fun...Discuss·27 readspostgres