Bookmarks tagged with #database.
Show all
Show all
Laravel Zero-Downtime Migrations: Expand and Contract Pattern | RichDynamix
A step-by-step guide to Laravel zero-downtime migrations with the expand and contract pattern: nullable expands, batched backfills, and flagged reads.
Saved
on: 2026-07-14
The challenges of soft delete
Exploring alternatives to the archived_at column pattern: triggers, application events, and WAL-based change data capture.
Saved
on: 2026-01-21
maxpert/marmot: A distributed SQLite server with MySQL wire compatible interface
A distributed SQLite server with MySQL wire compatible interface - maxpert/marmot
Saved
on: 2026-01-02
From Kevin Bacon to HNSW: the intuition behind semantic search and vector databases
An explainer to how modern fast and accurate vector searching works, with interactive demos.
Saved
on: 2025-11-12
Chapters 1-6
Counting (32 pages) Integer Generators (24 pages) Exotic Operators (40 pages) Constraints (19 pages) Trees (39 pages) Graphs (41 pages)
Saved
on: 2025-08-31
DSHR's Blog: Archival Storage
I gave a talk at the Berkeley I-school's Information Access Seminar entitled Archival Storage . Below the fold is the text of the talk with...
Saved
on: 2025-03-18
Exploring Concurrent Access Handling
Exploring Concurrent Access Handling (Published on Feb 9, 2025 - Version française)
Saved
on: 2025-02-11
Apache Kvrocks™
Apache Kvrocks is a distributed key value NoSQL database that uses RocksDB as storage engine and is compatible with Redis protocol.
Saved
on: 2025-01-23
outerbase/studio
A lightweight Database GUI in your browser. It supports connecting to Postgres, MySQL, and SQLite. - outerbase/studio
Saved
on: 2024-12-05
Foursquare's 104M Points of Interest
Benchmarks & Tips for Big Data, Hadoop, AWS, Google Cloud, PostgreSQL, Spark, Python & More...
Saved
on: 2024-11-24
Netflix’s Distributed Counter Abstraction
In our previous blog post, we introduced Netflix’s TimeSeries Abstraction, a distributed service designed to store and query large volumes of temporal event data with low millisecond latencies…
Saved
on: 2024-11-14
SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers) : Karwin, Bi
Bill Karwin has helped thousands of people write better SQL and build stronger relational databases. Now he’s sharing his collection of antipatterns—the most common errors he’s identified in those thousands of requests for help. Each chapter in this book helps you identify, explain, and correct a...
Saved
on: 2024-09-24
TIL: 8 versions of UUID and when to use them
Saved
on: 2024-08-26
"We ran out of columns" - The best, worst codebase
Saved
on: 2024-08-04
PostgreSQL is eating the database world
PostgreSQL isn’t just a simple relational database; it’s a data management framework with the potential to engulf the entire database realm. The trend of “Using Postgres for Everything” is no longer limited to a few elite teams but is becoming a mainstream best practice.
Saved
on: 2024-03-15
Welcome
Community website for Apache Superset™, a data visualization and data exploration platform
Saved
on: 2024-02-27
Stop building databases
Join me as we take a look at common application data patterns, and how they relate to the inner-workings of databases. In this post, we discuss data caching, indexing, optimistic mutations, and recursive cache invalidation. We will see how life might be easier if we could just use a frontend optimized database like SQLSync instead.
Saved
on: 2023-12-02
Horrible edge cases to consider when dealing with music
Personal blog of Julien (jvoisin) Voisin
Saved
on: 2023-11-12
Introducing “Database Performance at Scale”: A Free, Open Source Book
Discover new ways to optimize database performance and avoid common mistakes that impact latency and throughput.
Tags:
#database
Saved
on: 2023-10-06
Goodbye integers. Hello UUIDs!
Exploring the tradeoffs of different database indexes; from sequential integers, randomly generated UUIDs, to time-based identifiers and the latest & greatest UUIDv7
Saved
on: 2023-10-02
How Discord Stores Trillions of Messages
Engineer Bo Ingram shares insight into how Discord shoulders its traffic and provides a platform for our users to communicate.
Saved
on: 2023-03-08
Poor schemas, poor cataloguing: why music tagging sucks - the sporks space
One of the things that frustrates me with having a local music library is the tedium of tagging. While there are tools (like beets or MusicBrainz Picard) to make it easier, I feel there are fundamental issues with the design… Continue reading →
Saved
on: 2023-02-19
The Story behind ASINs (Amazon Standard Identification Numbers)
This post explains how Amazon replaced ISBNs with ASINs (Amazon Standard Identification Numbers) for its Catalog Database Key
Saved
on: 2023-01-25
Just Use Postgres for Everything
Startups use too much technology. My advice: Use Postgres for everything
Saved
on: 2022-12-11
Strategies for decreasing the number of queries in a Laravel app - Freek Va
Oh Dear is all-in-one solution to monitor your site that my buddy Mattias Geniar and I have created. It can monitoring uptime, certificates, broken links, scheduled jobs, and much more.
Under the hood, Oh Dear is a large Laravel application that performs many queries all of the time. To power future features, we've recently changed our database structure and refactored some pieces in our code base. We increased performance by decreasing the number of queries.
In this blog post, we'd like to to share some techniques that might be helpfull to increase the performance of your Laravel app too.
Saved
on: 2022-08-16
Changing tires at 100mph: A guide to zero downtime migrations | Kiran Rao
As a backend developer at a mobile app company, a common task was migrating a database schema.This could be to improve query performance, change column ...
Saved
on: 2022-05-05
Why I Built Litestream
Despite an exponential increase in computing power, our applications require more machines than ever because of architectural decisions made 25 years ago. You can eliminate much of your complexity and cost by using SQLite & Litestream for your production applications.
Saved
on: 2021-02-12
Some SQL Tricks of an Application DBA
Some tips and misconceptions about database development I gathered along the way.
Saved
on: 2020-07-29
Ordering database queries by relationship columns in Laravel
In this article I explain how to order database queries in Laravel by the value (column) of an Eloquent relationship. We look at has-one, belongs-to, has-many and belongs-to-many relationships.
Saved
on: 2020-06-11
Things I Wished More Developers Knew About Databases
A large majority of computer systems have some state and are likely to depend on a storage system. My knowledge on databases accumulated over time, but along the way our design mistakes caused data…
Tags:
#database
Saved
on: 2020-04-23
From 15,000 database connections to under 100: DigitalOcean's tale of tech debt | DigitalOcean
Helping millions of developers easily build, test, manage, and scale applications of any size - faster than ever before.
Saved
on: 2020-01-15
What Every Developer Absolutely, Postively Needs to Know about Database Indexing : r/PHP
Saved
on: 2020-01-04
Knight Lab's SQL Murder Mystery
Use SQL queries to solve the murder mystery. Suitable for beginners or experienced SQL sleuths.
Saved
on: 2019-12-16
Lessons learned scaling PostgreSQL database to 1.2bn records/month
This isn’t my first rodeo with large datasets. The authentication and product management database that I have designed for the largest UK public Wi-Fi provider had impressive volumes too. We were…
Saved
on: 2019-10-16
Prisma - Database tools for modern application development
Build, fortify, and grow your application easily with an intuitive data model, type-safety, automated migrations, connection pooling and caching.
Saved
on: 2019-04-08
Amazon Aurora ascendant: How we designed a cloud-native relational database
Saved
on: 2019-03-14
Move fast and migrate things: how we automated migrations in Postgres
At Benchling, we’re building a platform to help scientists do research. Hundreds of thousands of scientists across academia and enterprise clients use Benchling to store and analyze scientific data…
Tags:
#database
Saved
on: 2019-02-06
Trek10 | From relational DB to single DynamoDB table: a step-by-step explor
Trek10 specializes in leveraging the best tools and AWS managed services to design, build, and support cutting-edge solutions for our clients.
Tags:
#database
Saved
on: 2019-01-04
How to Manage Connections Efficiently in Postgres, or Any Database — Brandu
Hitting the limit for maximum allowed connections is a common operational problem in Postgres. Here we look at a few techniques for managing connections and making efficient use of those that are available.
Tags:
#database
Saved
on: 2018-10-16
DBMS Musings: NewSQL database systems are failing to guarantee consistency,
(Spanner vs. Calvin, Part 2) [TL;DR I wrote a post in 2017 that discussed Spanner vs. Calvin that focused on performance differences. Th...
Tags:
#database
Saved
on: 2018-09-21
SQL Keys in Depth
What database keys really are, and how to use them effectively.
Saved
on: 2018-01-02
Five sharding data models and which is right
At Citus we make it simple to shard PostgreSQL. So we’ve thought a lot about different data models for sharding. This post covers 5 different data models for sharding, from sharding by tenant (multi-tenant data models), sharding by geography, sharding by entity id, sharding a graph, and time-based partitioning.
Saved
on: 2017-08-29
Online migrations at scale
Online payment processing for internet businesses. Stripe is a suite of payment APIs that powers commerce for businesses of all sizes.
Saved
on: 2017-02-03
dbpatterns - create, share, explore database patterns
Saved
on: 2016-04-07
Amazon RDS - Servers for Hackers
I've gotten a few questions about how MySQL replication works within RDS. Amazon has a few concepts going on which makes the picture of how everything fits together a little hazy. Here's my attempt at clearing up how the RDS service works!
Saved
on: 2016-03-24
(The only proper) PDO tutorial
There are many tutorials on PDO already, but unfortunately, most of them fail to explain the real benefits of PDO, or even promote rather bad practices. The only two exceptions are [phptherightway.com](http://www.phptherightway.com/#pdo_extension) and [hashphp.org](http://wiki.hashphp.org/PDO_Tutorial_for_MySQL_Developers), but they miss a lot of important information. As a result, half of PDO's features remain in obscurity and are almost never used by PHP developers, who, as a result, are constantly trying to reinvent the wheel which *already exists in PDO.*
Saved
on: 2016-02-22
fgrehm/vagrant-mssql-express: Vagrant environment with Windows 2008 R2 SQ
Vagrant environment with Windows 2008 R2 + SQL Server Express 2008 - fgrehm/vagrant-mssql-express
Saved
on: 2016-01-16
Fieldbook: Create a database, as easily as a spreadsheet
Saved
on: 2015-12-18
How do I handle errors with PDO?
Parham re-introduces PDO ahead of the PHP 7 launch, preparing you for a transition from the soon-to-be removed insecure and deprecated mysql extension!
Saved
on: 2015-09-11
aws-redshift-shell/README.md at master · squidsolutions/aws-redshift-shell
Shell scripts for AWS Redshift clusters configuration, creation and administration - squidsolutions/aws-redshift-shell
Saved
on: 2015-06-03
https://github.com/robmorgan/phinx/blob/0.3.x-dev/README.md
Saved
on: 2014-10-17
eng-practices/Migrations_and_future_proofing.md at master · Prismatic/eng-p
Prismatic's Engineering Practices
Saved
on: 2014-09-24