Best of Database — March 2024
- 1
- 2
Community Picks·2y
The Faster Redis Alternative
KeyDB is a fully open source database and a faster drop-in alternative to Redis. It offers high throughput, supports various data structures, has multiple persistence options, and is scalable to any workload. KeyDB also has open source features such as MVCC non-blocking architecture, cross-region multi-master support, better EXPIRation, TLS encryption, and ModJS for creating custom commands.
- 3
Hacker News·2y
teableio/teable: ✨ A Super fast, Real-time, Professional, Developer friendly, No code database
Teable is a super fast, real-time, professional, developer-friendly, no-code database built on Postgres. It offers a simple, spreadsheet-like interface, supports various data views, and integrates with popular software tools. It aims to meet the evolving demands of modern software development.
- 4
10 Cool SQL Optimisations That do not Depend on the Cost Model
The post evaluates 10 SQL optimizations that do not depend on the cost model. It discusses the applications and support for transitive closure, removing 'silly' predicates, JOIN elimination, provably empty sets, and more.
- 5
- 6
- 7
- 8
Theo - t3․gg·2yI Suck At SQL, Now My DB Tells Me How To Fix It
Planet Scale introduces schema recommendations, a new feature that helps improve database performance by providing tailored recommendations based on production database traffic. The recommendations include adding indexes for inefficient queries, removing redundant indexes, preventing primary key ID exhaustion, and dropping unused tables.
- 9
- 10
Vlad Mihalcea·2y
PostgreSQL Index Types
This post explores PostgreSQL index types, including B+Tree, Hash, and GIN indexes. It discusses the benefits of using B+Tree indexes for filtering, range scans, and sorting. It explains how Hash indexes are useful for equality checks and saving space. It also explains how GIN indexes can speed up JSON-specific operations. The post concludes by mentioning other index types available in PostgreSQL.
- 11
Prisma in 100 Seconds
Prisma is an open source tool that provides a modern and safe way to work with databases. It allows you to write a schema to express your data and relationships, performs typesafe CRUD operations, handles migrations, and offers a convenient way to view and manage your data in the browser.
- 12
PlanetScale·2y
The problem with using a UUID primary key in MySQL
Learn about the downsides of using UUIDs as a primary key in your MySQL database, including insert performance and higher storage utilization. Discover best practices for minimizing the negative impacts and explore alternative ID types.
- 13
Waseem .NET Newsletter·2y
EP 53 : 8 Tips To Improve EF Core Performance
Tips to improve EF Core performance include using projections, async methods, compiled queries, avoiding non-cancellable queries, using database context pool, using IQueryable for multiple filters, using AsNoTracking for read-only operations, and implementing pagination.
- 14
gitconnected·2y
SQL Series: Preparing a Database Step by Step
This post discusses the process of preparing a database step by step for SQL learning, using a dataset related to sanitary inspections on cruise ships. It provides an overview of the dataset, instructions for creating a schema in MySQL Workbench, and guidance on loading data into the database.
- 15
Exploring Supabase, the Open Source Backend for Developers
Explore Supabase, an open source backend for developers with features like managed Postgres database, user authentication, real-time updates, file storage, and intuitive API & console. Compare it with proprietary solutions. Supabase offers transparency, customization, and clear pricing guidelines.
- 16
- 17
Milan Jovanović·2y
Implementing Soft Delete With EF Core
Learn how to implement soft deletes using EF Core. Soft deletes allow for the marking of records as deleted without actually removing them from the database. Interceptors and global query filters are used to handle soft-deleted data, and filtered indexes can improve query performance.
- 18
LogRocket·2y
Prisma ORM adoption guide: Overview, examples, and alternatives
Prisma is an open source ORM for Node.js and Typescript that simplifies database access and management. It provides a type-safe query builder and auto-generator. Prisma is compatible with several frontend technologies and offers features like automated migrations, type safety, and a great developer experience.
- 19
Supabase·2y
PostgREST Aggregate Functions
PostgREST v12 has released aggregate functions, which allow users to summarize data by performing calculations across groups of rows. These functions can be used directly through the PostgREST API, making data manipulation easier. Users can also use aggregate functions in conjunction with embedded resources to perform complex calculations. However, it is important to use aggregate functions safely to prevent potential performance issues.
- 20
The New Stack·2y
How to Write SQL Queries
SQL is a declarative language used for querying, analyzing, and manipulating data. It uses different elements like SELECT, FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY, OFFSET, and FETCH to retrieve and analyze data. SQL queries can be used to join tables, filter rows, aggregate data, and sort results. The GROUP BY clause is used to group rows with common values and the HAVING clause is used to filter the grouped rows based on a condition.
- 21
- 22
- 23
Code Maze·2y
Execute the SELECT WHERE NOT EXIST SQL Query Using LINQ
This article explains how to execute the SELECT WHERE NOT EXISTS SQL query using LINQ in C#. It covers different methods, such as using the Any method, the Join method for Left Anti-Join, and the Contains method. The article also includes a benchmark comparison of these methods.
- 24
