Bookmarks tagged with #database.
Show all
Show all
Introducing “Database Performance at Scale”: A Free, Open Source Book
So many things have to align perfectly for impressive database performance. You need to think hard about factors like: And that’s just scratching the surface.
Tags:
#database
Saved
on: 2023-10-06
SQL Join Flavors
There is more to SQL joins than you might think. Let's explore them a bit. We'll use two simple tables: companies and jobs they offer.
Saved
on: 2023-09-22
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.
Saved
on: 2022-08-16
Changing tires at 100mph: A guide to zero downtime migrations
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 names/types, or adapt data to new use cases.
Saved
on: 2022-05-05
Why I Built Litestream
tl;dr—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
Relinx
New kind of inventory tracking, simple, flexible yet powerful. Also, we have tools available to trace SOL Casinos gaming data and insights. It helps to track player behavior and preferences, monitor gaming activity, manage marketing and promotions, and perform a variety of other functions.
Tags:
#database
Saved
on: 2020-09-15
Some SQL Tricks of an Application DBA
When I started my career in development, my first job was a DBA. Back then, before AWS RDS, Azure, Google Cloud and the rest of them cloud services, there were two types of DBAs:
Saved
on: 2020-07-29
Ordering database queries by relationship columns in Laravel
In this article we're going to explore how to order database queries by the value (column) of an Eloquent relationship. For example, maybe we want to order some users by the name of their company, which is in a separate companies table.
Saved
on: 2020-06-11
Millions of tiny databases – the morning paper
This paper is a real joy to read. It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information.
Tags:
#database
Saved
on: 2020-03-05
What Every Developer Absolutely, Postively Needs to Know about Database Indexing
Thought this one was definitely worth sharing. I liked i at least.
https://www.youtube.com/watch?v=HubezKbFL7E
Saved
on: 2020-01-04
SQL Murder Mystery
There's been a Murder in SQL City! The SQL Murder Mystery is designed to be both a self-directed lesson to learn SQL concepts and commands and a fun game for experienced SQL users to solve an intriguing crime. This exercise is meant more as a way to practice SQL skills than a full tutorial.
Saved
on: 2019-12-16
Lessons learned scaling PostgreSQL database to 1.2bn records/month
Saved
on: 2019-10-16
Prisma - Database tools for modern application development
Prisma provides the best experience for your team to work and interact with databases. Even complex things like connection pooling, caching, real-time database subscriptions are a breeze with our products.
Saved
on: 2019-04-08
Geeks Tech Stack
Skip to main content Posts Database Internel Architecture: SQLite Introduction A database is an essential part of building a software system which used to store and read data efficiently.
Tags:
#database
Saved
on: 2019-03-17
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, assemble DNA sequences, and design experiments.
Tags:
#database
Saved
on: 2019-02-06
Trek10 | From relational DB to single DynamoDB table: a step-by-step explor
Is your data secure? Find out with our free IBM security assessment! Learn More → Serverless From relational DB to single DynamoDB table: a step-by-step exploration Just because it's NoSQL, doesn't mean it's non-relational Forrest Brazeal | Jan 02 2019 Seriously, watch that video, then come back
Tags:
#database
Saved
on: 2019-01-04
SchemaCrawler
SchemaCrawler is a free database schema discovery and comprehension tool. SchemaCrawler has a good mix of useful features for data governance. You can search for database schema objects using regular expressions, and output the schema and data in a readable text format.
Saved
on: 2018-12-30
How to Manage Connections Efficiently in Postgres, or Any Database — Brandu
You start building your new project. You’ve heard good things about Postgres, so you choose it as your database. As advertised, it proves to be a satisfying tool and progress is good.
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.
Tags:
#database
Saved
on: 2018-09-21
Select Star SQL
This is an interactive book which aims to be the best place on the internet for learning SQL. It is free of charge, free of ads and doesn't require registration or downloads. It helps you learn by running queries against a real-world dataset to complete projects of consequence.
Saved
on: 2018-09-04
SQL Keys in Depth
The internet is full of dogmatic commandments for choosing and using keys in relational databases. At times it verges on a holy war: should you use natural or artificial keys? Auto-incrementing integers, UUIDs?
Saved
on: 2018-01-02
Five sharding data models and which is right
Update in July 2023: Citus 12 allows you to shard your database by schema, or if you prefer, you can still use row-based sharding. Find out more in the Citus 12 blog post. When it comes to scaling your database, there are challenges but the good news is that you have options.
Saved
on: 2017-08-29
Online migrations at scale
Engineering teams face a common challenge when building software: they eventually need to redesign the data models they use to support clean abstractions and more complex features.
Saved
on: 2017-02-03
Database versioning best practices - Enterprise Craftsmanship
Keeping track of your application’s database is not an easy task. Database schemas tend to mismatch in different environments, data in one of the databases may miss some crucial piece of data. Such occasions can be irritating, especially when caught in production.
Tags:
#database
Saved
on: 2015-08-11