Best of Database — October 2023
- 1
- 2
freeCodeCamp·3y
PostgreSQL Course for Beginners
A comprehensive PostgreSQL course is available on the freeCodeCamp.org YouTube channel. It covers PostgreSQL introduction, installation, SELECT statement, WHERE clauses, advanced query structures, aggregate functions, and more. Suitable for developers, aspiring Database Administrators, computer science students, and tech enthusiasts.
- 3
- 4
Community Picks·3y
We migrated to SQL. Our biggest learning? Don’t use Prisma
A developer shares their experience migrating from MongoDB to Postgres and using Prisma for their backend. They highlight problems with Prisma's deployment, low performance, and lack of SQL-level joins. They ultimately recommend avoiding Prisma for production workloads.
- 5
Introducing “Database Performance at Scale”: A Free, Open Source Book
Introducing ‘Database Performance at Scale’: A Free, Open Source Book - ScyllaDB Discover new ways to optimize database performance and avoid common mistakes that impact latency and throughput. The complete 270-page book is available now, for free, and the digital version is available free of charge.
- 6
- 7
Dev Genius·3y
Microservices Architecture with Node.js: Building Scalable and Robust Applications
Microservices architecture involves breaking an application down into smaller, independent services that communicate with each other through APIs. Node.js is a popular choice for building microservices. The article provides a guide on setting up microservices architecture in Node.js using Seneca.js and explains how to connect microservices.
- 8
Pointer·3y
omnigres/omnigres: Postgres as a Platform
Omnigres is a developer-first application platform that allows you to deploy a single database instance to host your entire application. It supports running application logic inside or next to the database instance, provisioning deployment via Git or containers, serving HTTP, WebSocket, and other protocols, in-memory and volatile on-disk caching, routine application building blocks like authentication and authorization, reactive queries for database-modeled application logic, automagic remote APIs and form handling, and live data updates.
- 9
Supabase·3y
Dynamic Table Partitioning in Postgres
This article discusses the problem of storing large amounts of data in a single table in Postgres and explores the solution of table partitioning. Partitioning data in Postgres can help improve query performance, facilitate archiving and data loading, and prevent issues like slower SELECTs and INSERTs.
- 10
Goodbye to sequential integers, hello UUIDv7!
Buildkite has adopted UUIDv7 as the primary key for their data storage. UUIDs provide unique identifiers without the need for coordination, making them preferable in distributed databases. The random nature of non-time-ordered UUIDs can negatively affect database performance. By using time-ordered UUIDs, Buildkite saw a significant reduction in WAL rate and write IO, improving their database performance.
- 11
How to Automate Data Exports and Email Reports with Python – a Step-by-Step Guide
Learn how to automate data exports from a PostgreSQL database and send them as email attachments using Python. The tutorial covers setting up a virtual environment, extracting data from the database, converting data into an Excel sheet, and sending the sheet as an email attachment.
- 12
Performance Guide to create 100k records in less than 3s using Ruby on Rails
This article explores different methods to efficiently create 100,000 records in Ruby on Rails. It compares methods such as '.save', '.create', '.insert_all', '.upsert_all', and ActiveRecord-Import. The article provides benchmark results and recommendations for selecting the appropriate method based on the specific needs.
