Pinboard (barryf)
https://pinboard.in/u:barryf/public/
recent bookmarks from barryf
-
SQL or NoSQL? Why not use both (with PostgreSQL)?
2022-11-24T20:38:12+00:00
https://supabase.com/blog/sql-or-nosql-both-with-postgresql
barryfpostgresql nosql json database
https://pinboard.in/u:barryf/b:723d8674d6db/
-
dbdiagram.io
2021-07-02T14:19:03+00:00
https://dbdiagram.io/home
barryf
database erd model diagram
https://pinboard.in/u:barryf/b:7a4549a76812/
-
Cleaning Up Your Postgres Database
2021-05-23T09:04:39+00:00
https://blog.crunchydata.com/blog/cleaning-up-your-postgres-database
barryf Actionable steps on how to improve your Postgres database performance.]]>
postgres database performance
https://pinboard.in/u:barryf/b:1c11c1adfd25/
-
Upstash
2021-04-14T07:28:45+00:00
https://upstash.com/
barryf
serverless database redis
https://pinboard.in/u:barryf/b:48f7e1c84911/
-
scenic
2021-03-11T21:27:51+00:00
https://github.com/scenic-views/scenic
barryf
view postgresql rails database
https://pinboard.in/u:barryf/b:050ef4188307/
-
thoughtbot/parity
2021-01-25T11:43:04+00:00
https://github.com/thoughtbot/parity
barryf Shell commands for development, staging, and production parity for Heroku apps]]>
heroku postgres database
https://pinboard.in/u:barryf/b:d5a56498e8bb/
-
psql command line tutorial and cheat sheet
2020-11-19T20:21:13+00:00
https://tomcam.github.io/postgres/
barryfpostgres database
https://pinboard.in/u:barryf/b:2f3f4adabe38/
-
The Ten Rules for Data Modeling with DynamoDB
2020-04-08T18:32:28+00:00
https://www.trek10.com/blog/the-ten-rules-for-data-modeling-with-dynamodb
barryfdynamodb aws database
https://pinboard.in/u:barryf/b:a297bb50d890/
-
Recursive SQL Queries with PostgreSQL
2020-03-16T17:22:51+00:00
https://martinheinz.dev/blog/18
barryfpostgresql recursion graph database
https://pinboard.in/u:barryf/b:42522d10c5e6/
-
Prisma
2020-02-20T21:33:47+00:00
https://www.prisma.io/
barryf
orm database javascript
https://pinboard.in/u:barryf/b:fee72769848f/
-
knex
2018-12-03T13:09:05+00:00
https://www.npmjs.com/package/knex
barryf A batteries-included, multi-dialect (MSSQL, MySQL, PostgreSQL, SQLite3, Oracle (including Oracle Wallet Authentication)) query builder for Node.js and the Browser]]>
node javascript database query
https://pinboard.in/u:barryf/b:19e7feff2446/
-
sequelize
2018-12-03T13:08:27+00:00
https://www.npmjs.com/package/sequelize
barryf Sequelize is a promise-based Node.js ORM for Postgres, MySQL, SQLite and Microsoft SQL Server. It features solid transaction support, relations, read replication and more.]]>
node orm database javascript
https://pinboard.in/u:barryf/b:f5322dd23d13/
-
dynalite
2018-04-15T11:40:26+00:00
https://github.com/mhart/dynalite
barryf An implementation of Amazon's DynamoDB built on LevelDB]]>
aws dynamodb database
https://pinboard.in/u:barryf/b:e92256addaef/
-
Rails Database Best Practices
2018-01-04T17:29:18+00:00
https://blog.carbonfive.com/2016/11/16/rails-database-best-practices/
barryfrails database optimisation performance
https://pinboard.in/u:barryf/b:b21bb40b00fe/
-
N+1 Queries or Memory Problems: Why not Solve Both?
2017-05-25T11:12:25+00:00
https://blog.heroku.com/solving-n-plus-one-queries
barryfperformance rails database
https://pinboard.in/u:barryf/b:d335ead30ce8/
-
Sequel cheatsheet
2016-10-06T14:16:40+00:00
http://ricostacruz.com/cheatsheets/sequel.html
barryfsequel ruby database orm
https://pinboard.in/u:barryf/b:9d754b3a14c2/
-
How FriendFeed uses MySQL to store schema-less data
2016-01-14T10:46:59+00:00
https://backchannel.org/blog/friendfeed-schemaless-mysql
barryffriendfeed schemaless nosql mysql database
https://pinboard.in/u:barryf/b:ba17e5d38e8f/
-
PSequel
2014-12-03T16:06:40+00:00
http://www.psequel.com/
barryf
postgresql database postgres gui mac
https://pinboard.in/
https://pinboard.in/u:barryf/b:b4bdc8f36236/
-
cayley
2014-07-10T09:42:55+00:00
https://github.com/google/cayley
barryf
graph database google
https://pinboard.in/
https://pinboard.in/u:barryf/b:62637e7f2677/
-
PouchDB
2014-05-20T12:33:27+00:00
http://pouchdb.com/
barryf
database couchdb javascript offline sync
https://pinboard.in/
https://pinboard.in/u:barryf/b:d1b252ba5a08/
-
Firebase - Build Realtime Apps
2014-04-14T06:35:40+00:00
https://www.firebase.com/
barryf
database realtime api sync saas
https://pinboard.in/
https://pinboard.in/u:barryf/b:a64fcdcc16b0/
-
Web Hosting For App Developers – Marco.org
2014-03-27T16:36:09+00:00
http://www.marco.org/2014/03/27/web-hosting-for-app-developers
barryf
hosting server sysadmin database replication app
https://pinboard.in/
https://pinboard.in/u:barryf/b:f455e8735552/
-
Scaling PostgreSQL Performance Using Table Partitioning
2013-06-09T10:55:45+00:00
https://blog.engineyard.com/2013/scaling-postgresql-performance-table-partitioning
barryfpostgresql database scaling partitioning
https://pinboard.in/u:barryf/b:1943b9107c28/
-
Reco4j
2013-05-29T15:38:33+00:00
http://www.reco4j.org/
barryf
recommendation graph framework nosql database
https://pinboard.in/
https://pinboard.in/u:barryf/b:84b9b338a538/
-
Screencast: using ruby to add schema-less data to PostgreSQL
2013-03-17T17:41:58+00:00
http://railscasts.com/episodes/345-hstore
barryf
ruby hstore postgresql nosql activerecord database screencast
https://pinboard.in/
https://pinboard.in/u:barryf/b:81171327373c/
-
Handling Growth with Postgres
2013-01-26T17:36:32+00:00
http://instagram-engineering.tumblr.com/post/40781627982
barryf
postgres instagram database scaling
https://pinboard.in/u:barryf/b:a59765ddaad5/
-
Lanyrd's Big Move
2012-12-16T14:44:19+00:00
http://lanyrd.com/blog/2012/lanyrds-big-move/
barryf
mysql postgres database migration startup
https://pinboard.in/
https://pinboard.in/u:barryf/b:e657c1f2d05c/
-
y310/kodama
2012-12-03T11:54:53+00:00
https://github.com/y310/kodama
barryf
database mysql ruby replication binlog
https://pinboard.in/
https://pinboard.in/u:barryf/b:a426bd042df1/
-
Postgres.app
2012-07-19T20:20:13+00:00
http://postgresapp.com/
barryf
postgres postgresql database mac
https://pinboard.in/
https://pinboard.in/u:barryf/b:d3a3d56714c4/
-
octopus
2012-07-04T16:48:23+00:00
https://github.com/tchandy/octopus
barryf
activerecord sharding database ruby rails
https://pinboard.in/
https://pinboard.in/u:barryf/b:187154e2b544/
-
Riak
2011-11-10T17:27:11+00:00
http://basho.com/products/riak-overview/
barryf
riak database cluster opensource nosql
https://pinboard.in/u:barryf/b:9e2a2d6542b9/
-
5 subtle ways you’re using MySQL as a queue, and why it’ll bite you
2011-09-17T08:42:56+00:00
http://www.engineyard.com/blog/2011/5-subtle-ways-youre-using-mysql-as-a-queue-and-why-itll-bite-you/
barryf
queue database mysql percona
https://pinboard.in/u:barryf/b:637020583b77/
-
MongoHQ
2010-04-25T14:51:54+00:00
https://mongohq.com/home
barryf
mongodb cloud hosting database
https://pinboard.in/u:barryf/b:74c37451c523/
-
Redis cheat-sheet v1.0
2010-03-18T14:22:25+00:00
http://masonoise.wordpress.com/2010/03/17/redis-cheat-sheet-v1-0/
barryf
redis nosql database cheatsheet dev via:timblair
https://pinboard.in/u:barryf/b:27473639c485/
-
Geospatial Indexing - MongoDB
2010-03-13T16:49:36+00:00
http://www.mongodb.org/display/DOCS/Geospatial+Indexing
barryf
database mongodb geo map location nosql
https://pinboard.in/u:barryf/b:5519a1e4431e/
-
Saying Yes to NoSQL; Going Steady with Cassandra
2010-03-13T16:41:08+00:00
http://about.digg.com/blog/saying-yes-nosql-going-steady-cassandra
barryf
cassandra digg nosql mysql database architecture
https://pinboard.in/u:barryf/b:c6d9ee8cfbcf/
-
<3! — How to install MongoDB on OS X
2010-03-08T14:09:34+00:00
http://shiftcommathree.com/articles/how-to-install-mongodb-on-os-x
barryfmongo nosql mac database install
https://pinboard.in/u:barryf/b:427819f59fe0/
-
Why I think Mongo is to Databases what Rails was to Frameworks
2010-03-01T22:26:24+00:00
http://railstips.org/blog/archives/2009/12/18/why-i-think-mongo-is-to-databases-what-rails-was-to-frameworks/
barryfmongo nosql rails scaling sql document database
https://pinboard.in/u:barryf/b:128d90f0e79b/
-
Scaling Django
2010-03-01T22:24:38+00:00
http://djangoadvent.com/1.2/scaling-django/
barryf
django scaling database infrastructure work architecture caching sharding
https://pinboard.in/u:barryf/b:a65cf4ee422f/
-
Ticket Servers: Distributed Unique Primary Keys on the Cheap
2010-02-09T15:49:28+00:00
http://code.flickr.com/blog/2010/02/08/ticket-servers-distributed-unique-primary-keys-on-the-cheap/
barryf
flickr database unique key ha server
https://pinboard.in/u:barryf/b:7aa98885763b/
-
redis
2009-10-31T18:10:44+00:00
http://code.google.com/p/redis/
barryf
keyvalue persistence nosql database
https://pinboard.in/u:barryf/b:bc46b209e859/
-
Sphinx 0.9.9-rc2 - with SphinxQL
2009-04-09T20:30:39+00:00
http://sphinxsearch.com/news/37.html
barryf
database mysql sql sphinx search
https://pinboard.in/u:barryf/b:19d23cb3fdea/
-
xtrabackup-0.3, binaries and stream backup
2009-03-26T22:27:58+00:00
http://www.mysqlperformanceblog.com/2009/03/13/xtrabackup-03-binaries-and-stream-backup/
barryf
mysql backup innodb stream dba sysadmin work database
https://pinboard.in/u:barryf/b:e1dbdf849a47/
-
Jet Profiler for MySQL
2009-03-22T21:29:02+00:00
http://www.jetprofiler.com/
barryf
java database debug profiler optimisation dba sysadmin monitoring mysql
https://pinboard.in/u:barryf/b:769a089843b2/
-
Documents about MySQL query optimization
2009-03-13T22:27:51+00:00
http://hackmysql.com/documents
barryfmysql optimisation performance database query work dba
https://pinboard.in/u:barryf/b:6020df209c0c/
-
Anti-RDBMS: A list of distributed key-value stores
2009-02-27T16:23:41+00:00
http://www.metabrew.com/article/anti-rdbms-a-list-of-distributed-key-value-stores/
barryf
database keyvalue architecture memcached simpledb couchdb performance scaling
https://pinboard.in/u:barryf/b:78cd7ebb028a/
-
How FriendFeed uses MySQL to store schema-less data
2009-02-27T16:17:39+00:00
http://bret.appspot.com/entry/how-friendfeed-uses-mysql
barryf
friendfeed mysql scaling index database replication sharding innodb
https://pinboard.in/u:barryf/b:6dd2d0c91a50/
-
MySQLTuner
2008-12-11T20:12:11+00:00
http://wiki.mysqltuner.com/MySQLTuner
barryf
mysql mysqltuner optimise performance database perl dba sysadmin work
https://pinboard.in/u:barryf/b:3cf1257af84c/
-
Sequel Pro – MySQL database management app for Mac OS X
2008-11-16T14:02:09+00:00
http://www.mjmedia.com.au/sequel-pro.html
barryf
mac database mysql leopard cocoamysql
https://pinboard.in/u:barryf/b:6dee19fd69e6/
-
Obtaining the Master Replication Information on MySQL 5
2008-09-27T13:59:39+00:00
http://dev.mysql.com/doc/refman/5.0/en/replication-howto-masterstatus.html
barryfmysql database replication master sysadmin work
https://pinboard.in/u:barryf/b:b6872a622276/
-
Scaling Out
2008-08-25T10:35:47+00:00
http://www.facebook.com/note.php?note_id=23844338919
barryf
facebook architecture dev data loadbalancer level7 scaling web mysql replication database cache memcache
https://pinboard.in/u:barryf/b:e38cefba8aac/
-
log_queries_not_using_indexes
2008-08-13T19:54:54+00:00
http://optimmysql.blogspot.com/2008/05/variable-day-out-14-logqueriesnotusingi.html
barryf
mysql tuning performance index database application dev logging sql
https://pinboard.in/u:barryf/b:3615ad41cc08/
-
Drizzle, Clouds, "What If?"
2008-07-23T07:19:14+00:00
http://krow.livejournal.com/602409.html
barryf
mysql web community database opensource utf8 innodb
https://pinboard.in/u:barryf/b:8c15ed68ca9a/
-
Using A Quick & Easy SQLite Database
2008-07-20T09:28:32+00:00
http://camendesign.com/?200807101232
barryf
sqlite php pdo database sql dev
https://pinboard.in/u:barryf/b:d3d1da74d28f/
-
SQLEditor
2008-06-23T10:28:49+00:00
http://www.malcolmhardie.com/sqleditor/
barryf
database sql mac mysql entity er editor diagram design
https://pinboard.in/u:barryf/b:a9d8884bf5f6/
-
EXPLAIN Cheatsheet (MySQL)
2008-04-26T10:57:20+00:00
http://www.pythian.com/blogs/960/explain-cheatsheet
barryfcheatsheet database mysql reference sql explain monitoring performance sysadmin dev
https://pinboard.in/u:barryf/b:b1aad0319df3/
-
PostGIS
2008-04-12T17:32:48+00:00
http://www.postgis.org/
barryf
gis database postgresql sql opensource dev geo
https://pinboard.in/u:barryf/b:28e6c7021035/
-
CouchDB "Joins"
2008-04-12T11:25:56+00:00
http://www.cmlenz.net/archives/2007/10/couchdb-joins
barryf
couchdb database erlang json data architecture query
https://pinboard.in/u:barryf/b:33d94a118114/
-
The Death of Read Replication
2008-04-10T18:46:55+00:00
http://krow.livejournal.com/590912.html
barryf
mysql replication memcached scalability caching database scaling
https://pinboard.in/u:barryf/b:c3075cc1542a/
-
Master/Slave Databases with Ruby on Rails
2008-03-15T18:59:53+00:00
http://www.robbyonrails.com/articles/2007/11/15/master-slave-databases-with-ruby-on-rails
barryf
rails database activerecord mysql replication clustering plugin scaling masochism
https://pinboard.in/u:barryf/b:cc1bf5de2702/
-
HyperDB « WordPress Codex
2008-03-07T16:59:37+00:00
http://codex.wordpress.org/HyperDB
barryf
scaling wordpress php performance hyperdb database scalability replication partitioning failover
https://pinboard.in/u:barryf/b:d0271aad3286/
-
MySQL Workbench
2008-03-05T08:21:58+00:00
http://dev.mysql.com/workbench/
barryfmysql database workbench design dev model opensource sql diagram
https://pinboard.in/u:barryf/b:0a59d6c53301/
-
Agile Ajax: Using ActiveRecord to Migrate Legacy Data
2008-03-05T08:21:24+00:00
http://blogs.pathf.com/agileajax/2008/03/using-activerec.html
barryfactiverecord database rails legacy migration data dev
https://pinboard.in/u:barryf/b:41b8f993c75b/
-
Upgrading from MySQL 4.1 to 5.0
2008-03-03T00:47:58+00:00
http://dev.mysql.com/doc/refman/5.0/en/upgrading-from-4-1.html
barryfdatabase migration mysql upgrade mysql5
https://pinboard.in/u:barryf/b:b2b2c62ba57e/
-
How to Avoid Hanging Yourself with Rails
2008-03-02T23:54:59+00:00
http://work.rowanhick.com/2008/02/12/how-to-avoid-hanging-yourself-with-rails/
barryf
activerecord bestpractice database optimise performance rails scaling
https://pinboard.in/u:barryf/b:ef74cad4d2d9/
-
PERCONA - Scaling High Performance Web Sites
2008-02-25T07:21:01+00:00
http://www.percona.com/
barryf
mysql performance consulting dba database
https://pinboard.in/u:barryf/b:a738c891eb43/
-
INFORMATION_SCHEMA Support in MySQL, PostgreSQL
2008-02-21T21:13:26+00:00
http://www.petefreitag.com/item/666.cfm
barryfdatabase mysql postgresql metadata sql schema dev
https://pinboard.in/u:barryf/b:c8fca2c1f472/
-
Jeremy Cole on MySQL Replication
2008-02-16T13:31:52+00:00
http://www.mysqlperformanceblog.com/2006/05/27/jeremy-cole-on-mysql-replication/
barryf
mysql performance replication myisam innodb sysadmin database
https://pinboard.in/u:barryf/b:5db14e8fa3df/
-
Scale rails from one box to three, four and five
2008-01-19T17:42:03+00:00
http://www.caboo.se/articles/2007/7/29/scale-rails-from-one-box-to-three-four-and-five
barryfrails caching database deployment memcache performance scalability scaling server
https://pinboard.in/u:barryf/b:ef672802d897/
-
Amazon SimpleDB thoughts
2007-12-23T15:18:51+00:00
http://snarfed.org/space/amazon%20simpledb%20thoughts
barryf
amazon simpledb database aws
https://pinboard.in/u:barryf/b:0a4c8a87b1b6/