Carlos Carneirocarlos.hashnode.net·Nov 29, 2020The easiest way to install any database on your machineSetting up databases can potentially mess up your environment especially if you work with multiple different databases. I used to install them directly on my machine. I am here today to teach you how to do so but in a totally segregated environment a...Discuss·21 likes·108 readsMini TutorialsDocker
Eric Goldmangoldman.hashnode.net·Dec 16, 2020How to use Postgres Arrays to Unleash AirtableAirtable is a bit of a tease. While it looks and feels like a database, you can't query it like a database. That's why I'm helping build Sync Inc. In this guide, you'll first connect Airtable to Postgres using Sync Inc. Then, you'll unlock your Airta...Discuss·12 likes·52 readsPostgreSQL
Leandro Proençaleandronsp.hashnode.net·Sep 16, 2021A powerful full-text search in PostgreSQL in less than 20 linesThis blogpost will guide you to understand the fundamental pieces needed to implement a good enough full-text search using PostgreSQL. Spoiler alert: for those curious people looking for a "okay, just show me a full-text search with ranking and fuzz...jacobbill and 2 others are discussing this3 people are discussing thisDiscuss·9 likes·14.9K readsPostgreSQLPostgreSQL
Lucas Schiavinilucas-schiavini.hashnode.net·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
kiran sabnekiransabne.hashnode.net·Apr 11, 2023Handling Exceptions in PostgresIn PostgreSQL, exception handling is implemented using the PL/pgSQL procedural language, which extends the capabilities of SQL with additional programming constructs, such as variables, loops, and conditionals. PL/pgSQL provides a comprehensive excep...DiscussPostgreSQL
Daniel Lopesdanieljalopes.hashnode.net·Feb 12, 2023Flyway 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...Discuss·40 readspostgres
Itay Braunpostgres.hashnode.net·Feb 7, 2023Postgres Missing Statistics - A quick fix for a big problemWhat are Postgres Statistics? The statistics collect information about count accesses to tables and indexes in both disk block and individual row terms. It also tracks the total number of rows in each table, and information about vacuum, and analyzes...Discuss·26 readsPostgreSQL
Brian Budbrianbud.hashnode.net·Feb 1, 2023How to set Environment Variable on PostgreSQL on Windows.Did you receive this error too?'psql' is not recognized as an internal or external command, operable program or batch file. I was working on a codebase in which it was my first time installing Postgres. However, I had to spend a lot of time figuring ...Discuss·36 readsPostgreSQL
Dmitry Narizhnykhdataflowkit.hashnode.net·Jan 29, 2023Streaming data from MySQL to Postgres.Streaming data from a MySQL database to a PostgreSQL database can be a useful way to move data between systems or to create a real-time replica of a database for reporting and analysis. One way to accomplish this is through the use of Change Data Cap...DiscussPostgreSQL
Sushil Tiwarisusilnem.hashnode.net·Jan 7, 2023Install PostgreSQL and pgadmin4 on your Ubuntu EasilySo, Recently I had to rebuild my operating system, and I was having trouble setting up my development environment, which includes PostgreSQL, on the new installation. As you may know, I work a lot with PostgreSQL, and I needed to install it before I ...Discuss·36 readsPostgreSQL
Miguel Angel Acevedofaultydev.hashnode.net·Jan 4, 2023pg-mem and uuid_generate_v4() mockpg-mem is an open-source project for javascript (works in Node.js and the browser) where you can mock a Postgres server in memory, is pretty cool to use it on unit and local tests. And it comes with its own limitations, by default, pg-mem has no nati...Discuss·88 readsPostgreSQL
Soroush Fathisoroushfathi.hashnode.net·Jan 3, 2023PostgreSQL🐘what is Postgres? if you've been looking at job postings recently, you may have seen a lot of them are now looking for Postgres experience that's because a lot of tech companies are moving to Postgres or starting out a new stack. why are the likes...Discuss·4 likes·105 readsPostgreSQL
Atharva Pandeycoinademia.hashnode.net·Dec 16, 2022Optimizing PostgreSqlAs a database administrator or developer, it is important to make sure that your PostgreSQL queries are optimized for maximum performance. Poorly optimized queries can lead to slow performance, which can have a negative impact on the user experience ...Discuss·30 readsPostgreSQL
