barryf + database   109

knex
> 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 
december 2018 by barryf
sequelize
> 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 
december 2018 by barryf
dynalite
> An implementation of Amazon's DynamoDB built on LevelDB
aws  dynamodb  database 
april 2018 by barryf
PSequel
PostgreSQL GUI Tool for Mac OS X
postgresql  database  postgres  gui  mac 
december 2014 by barryf
cayley
Open source graph database from Google
graph  database  google 
july 2014 by barryf
PouchDB
It enables applications to store data locally while offline, then synchronize it with CouchDB and compatible servers when the application is back online
database  couchdb  javascript  offline  sync 
may 2014 by barryf
Firebase - Build Realtime Apps
"A powerful API to store and sync data in realtime."
database  realtime  api  sync  saas 
april 2014 by barryf
Web Hosting For App Developers – Marco.org
I especially like the advice on backing up databases via slaves.
hosting  server  sysadmin  database  replication  app 
march 2014 by barryf
Reco4j
Open source project that aims at developing a recommendation framework based on graph data sources
recommendation  graph  framework  nosql  database 
may 2013 by barryf
Screencast: using ruby to add schema-less data to PostgreSQL
With hstore you can add schema-less data to PostgreSQL. This allows you to store model attributes without creating separate database columns. Watch how to do this using the activerecord-postgres-hstore gem.
ruby  hstore  postgresql  nosql  activerecord  database  screencast 
march 2013 by barryf
y310/kodama
MySQL replication listener based on ruby-binlog. Kodama provides a simple DSL to easily write your own replication listener. Can be used to do things like replicate from MySQL to Postgres, etc.
database  mysql  ruby  replication  binlog 
december 2012 by barryf
Postgres.app
"The easiest way to run PostgreSQL on the Mac"
postgres  postgresql  database  mac 
july 2012 by barryf
octopus
Database sharding for activerecord (Ruby)
activerecord  sharding  database  ruby  rails 
july 2012 by barryf
Riak
Scalable, distributed, master-less database designed to work in the cloud.
riak  database  cluster  opensource  nosql 
november 2011 by barryf
5 subtle ways you’re using MySQL as a queue, and why it’ll bite you
Percona on why MySQL (or any database) is a bad choice for a queue
queue  database  mysql  percona 
september 2011 by barryf
MongoHQ
Cloud-based hosted database solution for MongoDB
mongodb  cloud  hosting  database 
april 2010 by barryf
Redis cheat-sheet v1.0
A handy three-page document covering all of Redis's commands and what they do
redis  nosql  database  cheatsheet  dev  via:timblair 
march 2010 by barryf
Geospatial Indexing - MongoDB
Now supports "order by distance from"
database  mongodb  geo  map  location  nosql 
march 2010 by barryf
Saying Yes to NoSQL; Going Steady with Cassandra
Commentary of Digg's move from MySQL to NoSQL through Cassandra
cassandra  digg  nosql  mysql  database  architecture 
march 2010 by barryf
Scaling Django
Detailed piece that focuses on Django but has lessons for everyone on scaling, caching, load balancing, queuing, sharding, etc.
django  scaling  database  infrastructure  work  architecture  caching  sharding 
march 2010 by barryf
Ticket Servers: Distributed Unique Primary Keys on the Cheap
How Flickr keeps numeric IDs unique across multiple databases
flickr  database  unique  key  ha  server 
february 2010 by barryf
redis
Persistent key-value database with libraries in all main languages
keyvalue  persistence  nosql  database 
october 2009 by barryf
Sphinx 0.9.9-rc2 - with SphinxQL
It now pretends to be a MySQL database so you can write SELECT queries
database  mysql  sql  sphinx  search 
april 2009 by barryf
xtrabackup-0.3, binaries and stream backup
Hot backup InnoDB databases to a remote box via a stream
mysql  backup  innodb  stream  dba  sysadmin  work  database 
march 2009 by barryf
Jet Profiler for MySQL
Java desktop MySQL profiler using native commands such as SHOW PROCESSLIST
java  database  debug  profiler  optimisation  dba  sysadmin  monitoring  mysql 
march 2009 by barryf
Anti-RDBMS: A list of distributed key-value stores
Stretches my little brain a bit, but this is a comprehensive breakdown of k/v stores and their drawbacks.
database  keyvalue  architecture  memcached  simpledb  couchdb  performance  scaling 
february 2009 by barryf
How FriendFeed uses MySQL to store schema-less data
Compressed python pickles are stored in an entities table with other tables storing indexes of this data. Uses normal MySQL replication and transactions via InnoDB but without time-consuming index rebuilds whenever they add features.
friendfeed  mysql  scaling  index  database  replication  sharding  innodb 
february 2009 by barryf
MySQLTuner
Perl script that suggets improvements to your MySQL config
mysql  mysqltuner  optimise  performance  database  perl  dba  sysadmin  work 
december 2008 by barryf
Scaling Out
Facebook's two data centres: for each update they include instruction in MySQL replication log to expire the object in memcache. Whenever user updates their data a cookie is set and for next 20s the LB uses Level 7 to send them to the master data centre so the slave has time to catch up and expire the cache.
facebook  architecture  dev  data  loadbalancer  level7  scaling  web  mysql  replication  database  cache  memcache 
august 2008 by barryf
log_queries_not_using_indexes
Hugely useful MySQL parameter. The post's author says he'll often design an application without indexes and then use this parameter (in development) to add indexes where needed
mysql  tuning  performance  index  database  application  dev  logging  sql 
august 2008 by barryf
Drizzle, Clouds, "What If?"
A new project to create a slimmed down MySQL targeted at web apps - UTF8, InnoDB and no stored procedures or other guff
mysql  web  community  database  opensource  utf8  innodb 
july 2008 by barryf
Using A Quick & Easy SQLite Database
Example uses PHP and PDO to connect to SQLite
sqlite  php  pdo  database  sql  dev 
july 2008 by barryf
SQLEditor
Slick database diagrammer for Mac. Will also generate DDL and other database functions
database  sql  mac  mysql  entity  er  editor  diagram  design 
june 2008 by barryf
PostGIS
PostGIS adds support for geographic objects to PostgreSQL for geographic information systems (GIS)
gis  database  postgresql  sql  opensource  dev  geo 
april 2008 by barryf
CouchDB "Joins"
This seems like a lot of faffing to my relational brain, but handy to know how to achieve it
couchdb  database  erlang  json  data  architecture  query 
april 2008 by barryf
The Death of Read Replication
Build objects from data stored in MySQL and push those objects into memcached
mysql  replication  memcached  scalability  caching  database  scaling 
april 2008 by barryf
Master/Slave Databases with Ruby on Rails
Masochism: split reads and writes to two different databases
rails  database  activerecord  mysql  replication  clustering  plugin  scaling  masochism 
march 2008 by barryf
HyperDB « WordPress Codex
PHP multi-database library: partitioning, replication and failover
scaling  wordpress  php  performance  hyperdb  database  scalability  replication  partitioning  failover 
march 2008 by barryf
How to Avoid Hanging Yourself with Rails
Useful tips on avoiding ActiveRecord magic creating inefficient queries
activerecord  bestpractice  database  optimise  performance  rails  scaling 
march 2008 by barryf
Jeremy Cole on MySQL Replication
"As you probably know MyISAM uses buffered IO so if master crashes you’re out of sync anyway - whatever sync_binlog option was set to"
mysql  performance  replication  myisam  innodb  sysadmin  database 
february 2008 by barryf
Amazon SimpleDB thoughts
Odd that it doesn't support full-text search and, especially, sorting. Not liking that query syntax much either.
amazon  simpledb  database  aws 
december 2007 by barryf
Amazon SimpleDB
Launch announcement of SimpleDB
amazon  database  simpledb  aws 
december 2007 by barryf
glTail.rb - realtime logfile visualization
Watches logfiles (Apache, Rails, IIS, MySQL, etc.) and displays pretty effects
analysis  animation  apache  database  monitoring  network  internet  http  web  sysadmin  statistics  rails 
october 2007 by barryf
Multiple Database Connections in Ruby on Rails (ActiveDelegate)
Enables master/slave replication arrangements - write to master; read from slave
rails  database  activerecord  deployment  performance  replication  scaling  mysql  server  sysadmin  dev 
october 2007 by barryf
MySQL Toolkit
Debugging and analysis tools
mysql  database  debug  analysis  dev  sysadmin 
september 2007 by barryf
Rail Spikes: (One reason why) MySQL sucks
Remember not to use :text for selectable columns in migrations in MySQL < 5.0.3
myqsl  rails  database  optimisation  query 
september 2007 by barryf
Revolution On Rails: ActsAsReadonlyable
For forcing read-only in Rails - when using slave databases
activerecord  database  replication  plugin  rails  scalability  scaling 
july 2007 by barryf
So long, migrations
Makes so much more sense to me - I hate switching between models and migration files. Can this please be a plugin or in the core and not just Hobo?
rails  database  model  migration  hobo  web  dev 
july 2007 by barryf
Apache Derby
Small Java DBMS with embedded JDBC driver. Will be distributed as part of CF8
apache  coldfusion  database  dev  jdbc  rdbms 
may 2007 by barryf
RedHill Consulting, Pty. Ltd. - Ruby on Rails Plugins (FK migrations)
Generates Foreign Keys when creating tables as part of migrations in Rails
database  plugin  rails  migrations  foreignkey  web  dev 
april 2007 by barryf
xlab » Speed up Mail.app
Nice hack to reindex/vacuum the internal SQLLite database
sqllite  mail  mac  optimise  database  speed  performance 
march 2007 by barryf
« earlier      
per page:    204080120160

related tags

activerecord  advocacy  amazon  analysis  animation  apache  api  app  application  architecture  authentication  autoincrement  aws  backup  bbc  bestpractice  binlog  cache  caching  cassandra  cheatsheet  cloud  cluster  clustering  cocoamysql  coldfusion  community  consulting  couchdb  data  database  dba  debug  delicious  deployment  design  dev  diagram  digg  django  document  driver  dynamodb  editor  enterprise  entity  er  erlang  explain  facebook  failover  flickr  foreignkey  framework  free  friendfeed  geo  gis  google  graph  gui  ha  hierarchy  hobo  hosting  hstore  http  hyperdb  index  infrastructure  innodb  instagram  install  internet  java  javascript  jdbc  joyent  jrun  json  key  keyvalue  layout  legacy  leopard  level7  loadbalancer  location  log4j  logging  mac  mail  map  masochism  master  media  memcache  memcached  metadata  migration  migrations  model  mongo  mongodb  mongrel  monitoring  mv  myisam  myqsl  mysql  mysql5  mysqltuner  network  node  nosql  offline  omnigraffle  opensource  optimisation  optimise  oracle  orm  partitioning  password  pdo  percona  performance  perl  persistence  php  plugin  postgres  postgresql  productivity  profiler  query  queue  rails  rake  rdbms  realtime  recommendation  redis  reference  replication  rest  riak  ruby  s3  saas  scalability  scaling  schema  schemaless  screencast  search  security  sequel  server  sessions  set  sharding  simpledb  software  speed  sphinx  sql  sqlite  sqllite  sqlserver  startup  statistics  stream  sync  sysadmin  tags  template  text  tree  tuning  tv  uk  uml  unique  upgrade  url  useful  utf8  via:timblair  video  web  web2.0  wireframe  wordpress  work  workbench 

Copy this bookmark:



description:


tags: