Posts tagged database

Contribute

The Wiki for Robot Builders.

35% Faster Than The Filesystem

An interesting study of performance. It seems hard to believe.

GeorgeKaraszi/ActiveRecordExtended: Adds additional postgres functionality to an ActiveRecord / Rails application

Adds additional postgres functionality to an ActiveRecord / Rails application - GeorgeKaraszi/ActiveRecordExtended: Adds additional postgres functionality to an ActiveRecord / Rails application

flyerhzm/bullet: help to kill N+1 queries and unused eager loading

help to kill N+1 queries and unused eager loading. Contribute to flyerhzm/bullet development by creating an account on GitHub.

The Basics of Database Sharding - Brent Ozar Unlimited®

There are many ways to scale out your database; many of these techniques require advanced management and expensive add-ons or editions. Database sharding is a flexible way of scaling out a database. In this presentation, Jeremiah Peschka explains how to scale out using database sharding, covers basic techniques, and shares some of the pitfalls. This...

Sharding your database

I’m increasingly encountering users on Heroku that are encountering the need to shard their data. For most users this is something you delay as long as possible as you can generally go for sometime before you have to worry about it. Additionally scaling up your database is often a reasonable approach early on and something I encourage as a starting point as scaling up is easy to do with regards to databases. However, for the 1% of users that do need to shard when the time comes many are left wondering where to start, hence the following guide.

Building Scalable Databases: Pros and Cons of Various Database Sharding Schemes - Dare Obasanjo

OpiniDatabase sharding is the process of splitting up a database across multiple machines to improve the scalability of an application. The justification for database sharding is that after a certain scale point it is cheaper and more feasible to scale a site horizontally by adding more machines than to grow it vertically by adding beefier servers.

Import CSV File Into PosgreSQL Table

In this tutorial, we will show various ways to import a CSV file into a PosgreSQL table.

Scaling relational SQL databases

A list of things that we can do when we need to scale a SQL database.

nocodb/nocodb

🔥 🔥 The Open Source Airtable alternative. Contribute to nocodb/nocodb development by creating an account on GitHub.

Rake Task for Database Population

Rake Task for Database Population · GitHub

Modli : NodeJS Data Modeling, Versioning and CRUD

Data modeling, versioning and CRUD made easy

Sharding your database Craig Kerstiens

I’m increasingly encountering users on Heroku that are encountering the need to shard their data. For most users this is something you delay as long as possible as you can generally go for sometime before you have to worry about it. Additionally scaling up your database is often a reasonable approach early on and something I encourage as a starting point as scaling up is easy to do with regards to databases. However, for the 1% of users that do need to shard when the time comes many are left wondering where to start, hence the fo...

Mongoose ODM v4.1.6

Indexes on Rails: How to make the most of your Postgres database - Karol Galanciak - Ruby on Rails and Ember.js consultant

Excellent advanced info on crating dB indexes, looking at query plans to understand performance.

Multiple Databases with Active Record — Ruby on Rails Guides

The new rails guide on multi databases in activerecord

Comparing Database Types: How Database Types Evolved to Meet Different Needs | Prisma

Really nice taxonomy of database types in history.

Why databases use ordered indexes but programming uses hash tables (evanjones.ca)

A great analysis about a question that I had not thought of but is pretty interesting now that you mention it!