Lucas Schiavinilucas-schiavini.hashnode.dev·Jul 16, 2024cost of ignoranceI have had very little backend experience until today(July 7th). I spent the last 3 days debugging how to self host supabase. Because I didn't know how to roll my own auth, i did do my own auth in 2019, but its so long ago and i remember it being so ...Discussclaude
Tinotenda Joeblog.britelink.io·Jul 15, 2024SQL JoinsSo here we are again, deep in the trenches of development. It's fascinating how, as developers, we often think we know a lot, but in reality, sometimes what we know is just the tip of the iceberg. In fact, a good 90% of the time, what we think we kno...DiscussSQL
Nkem Onyemachinkem.hashnode.dev·Jun 19, 2024Streamlining Database Management :Deploying PostgreSQL with Docker and PythonIntroduction Docker is an open-source platform that enables developers to automate the deployment, scaling, and management of applications using containerisation. It provides the capability to create, deploy, and manage containers, ensuring that appl...DiscussPostgreSQL
Sai SrirampurforPeerDB Blogblog.peerdb.io·Jun 13, 2024Overcoming Pitfalls of Postgres Logical DecodingAt PeerDB, we are building a fast and simple way to replicate data from Postgres to data warehouses like Snowflake, ClickHouse etc. and queues such as Kafka, Redpanda etc. We implement Postgres Change Data Capture (CDC) to reliably replicate changes ...Discuss·3.1K readsPostgreSQL
Jamey Bartondbajamey.hashnode.dev·Jun 10, 2024How to list all available tables in PostgreSQL?Checking the list of database tables is a common task that might be performed multiple times daily, and major database management systems provide built-in methods for this purpose. PostgreSQL offers several methods that will illustrate using the SQL ...DiscussPostgreSQL
Vishal Sharmacodreline.hashnode.dev·Jun 8, 2024How to set up a Postgres Database using Docker?Managing databases efficiently is crucial in the ever-evolving landscape of modern software development. PostgreSQL, a powerful open-source relational database, has become a go-to choice for many developers due to its robustness, extensibility, and a...DiscussPostgreSQL
Jamey Bartondbajamey.hashnode.dev·Jun 6, 2024PostgreSQL List Schemas: Various Ways to Show All SchemasPostgreSQL is one of many popular relational databases, known for its reliability, extensibility, and robust feature set, making it a preferred choice for many. When working with PostgreSQL, grasping the database schema is equal to understanding its ...DiscussPostgreSQL
Jamey Bartondbajamey.hashnode.dev·May 27, 2024How to duplicate a table in PostgreSQLCopying a database table (or duplicating it, for that matter) is one of those basic operations that can be performed for a variety of reasons. Let's have an overview of the most common situations in which you need to copy PostgreSQL tables—and the me...DiscussPostgreSQL
Sai SrirampurforPeerDB Blogblog.peerdb.io·May 8, 2024Row-level transformations in Postgres CDC using LuaEarlier this week, we launched PeerDB Streams, our latest product offering for real-time replication from Postgres to queues and message brokers such as Kafka, Redpanda, Google PubSub, Azure Event Hubs, and others. Today, we are announcing one of the...Discuss·1 like·1.2K readsPostgreSQL
Sai SrirampurforPeerDB Blogblog.peerdb.io·May 6, 2024PeerDB Streams - Simple, Native Postgres Change Data CaptureWe spent the past 7 months building a solid experience to replicate data from Postgres to Data Warehouses such as Snowflake, BigQuery, ClickHouse and Postgres. Now, we want to expand and bring a similar experience for Queues. With that spirit, we are...Richard Christopher and 1 other are discussing this2 people are discussing thisDiscuss·3 likes·3.6K readsPostgreSQL