Bookmarks tagged with #database.
Show all
Show all
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
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
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