infovore + database   24

"Given a legacy database, sandman not only gives you a REST API, it gives you a beautiful admin page and opens your browser to the admin page. It truly does everything for you." Very nice.
database  utility 
january 2014 by infovore
Composite Primary Keys
Composite keys for Rails/ActiveRecord. Really does appear to work, too, which is nice.
activerecord  database  keys  composite  programming  rubyonrails  ruby 
july 2010 by infovore
Taps for Easy Database Transfers
"Taps is a temporary web service you run on a server that has access to the database you want to export. You can then run the client to connect to that service and pull data out of it in chunks. It works through firewalls, doesn’t require a direct ssh connection, and - best of all - it’s database independent. So you can export from a MySQL database and import to PostgreSQL, or vice versa."
database  ruby  export  backup  development 
january 2010 by infovore
Heroku | Push and Pull Databases To and From Heroku
"A frequent question people ask us is “how do I transfer my database between my local workstation and my Heroku app?”" The answer is: using taps. Database push/pull, to/from Heroku, and to/from different database vendors. Very, very clever.
ruby  database  deployment  heroku 
march 2009 by infovore
Giant Bomb API Now Available -
"Have you ever wanted to sink your hooks into a gaming database full of release dates, artwork, games, platforms, and other sorts of related data? I'm going to guess that, for the bulk of you, the answer's probably no. But if you're out there wondering what to do next with your developer-savvy smarts, you've got another big source to pull data from. The Giant Bomb API is now available for non-commercial use." Giant Bomb really are doing some pretty interesting stuff, alongside their more traditional content.
games  api  resource  database  giantbomb 
january 2009 by infovore
Sequel Pro – MySQL database management app for Mac OS X
"Sequel Pro is the perfect tool for working with database-driven websites and applications." Leopard-only MySQL management application; forked out of the long-neglected CocoaMySQL.
leopard  macosx  web  database  mysql  utility  application 
august 2008 by infovore
"Are you tired of browser-based games that are thinly veiled interfaces for databases? Finally, there's a game that just is a database!" This looks awesome.
mysql  games  database  programming 
august 2008 by infovore
RailRoad diagrams generator
"RailRoad is a class diagrams generator for Ruby on Rails applications." Much like MattB's original .dot generator, but perhaps a bit more advanced. Useful!
visualization  information  database  diagram  development  rubyonrails  ruby  rails 
may 2008 by infovore
"FixtureReplacement is a Rails plugin that provides a simple way to quickly populate your test database with model objects without having to manage multiple, brittle fixture files." Looks very handy indeed.
rails  testing  database  fixtures  plugin  ruby  rubyonrails 
april 2008 by infovore
nick - Now I understand what they mean by tabular data (or: building a relational database using jQuery and <TABLE> tags)
"I thought, why not build a relational database in HTML? So I did. I even got inner joins working." This is insane. Great, but insane.
jquery  database  html  hack  crazy  javascript 
april 2008 by infovore
thinking about spreadsheets while washing the dishes (tecznotes)
"The spreadsheet has an older, wiser cousin, and it is called database."
spreadsheet  database  data  music  itunes  lastfm  metaphor  mentalmodel 
february 2008 by infovore
"DataMapper is a Object Relational Mapper written in Ruby. The goal is to create an ORM which is fast, thread-safe and feature rich." Looks very interesting; I rather like the migration-within-the-model thing (a la Django). One to watch out for.
ruby  database  orm  programming  development  datamapper 
november 2007 by infovore
RubyForge: Sequel: Project Info
Nice database front-end that's not a full ORM, but useful for boring db maintenance, that's for sure.
ruby  sql  database 
july 2007 by infovore
How to find the max row per group in SQL without subqueries - Xaprb
As with so many other SQL challenges, if you re-phrase the question, it’s easy to select the maximum or minimum row per group without subqueries. The key is to understand what you want, and to be able to word the problem in a way that translates from En
sql  mysql  database  programming  performance  howto 
may 2007 by infovore
Revolution On Rails: DB migrations with a twist
Using migrations on a large scale, with lots of advice for doing so, including numbering migrations with timestamps rather than sequential integers (to prevent clashes).
rails  rubyonrails  database  migrations  development 
march 2007 by infovore
err.the_blog.find_by_title('Sessions N Such')
Sessions in Rails are not black and white. Please stop treating them as such.
rails  ruby  rubyonrails  sessions  database 
september 2006 by infovore
MySQL Performance Blog
Ooh, crunch - nitty, gritty, technical (and often above-my-head) blog devoted to MySQL performance. But lots of good data in here nontheless. Mmn.
mysql  database  blog 
may 2006 by infovore
Getting Started With ActiveRecord Migrations
Because, you know, at some point I'm going to have to dive into using them quite hard...
database  development  deployment  versioncontrol  rails  rubyonrails 
may 2006 by infovore
How to use SQLite with Ruby On Rails
For all those times when a real database is overkill
sqlite  ruby  rails  rubyonrails  development  programming  database 
march 2006 by infovore
Php Object Generator (v1.5 rev3) - Open Source Object Relational Mapping PHP Code Generator
Quite nice. Generates data objects for PHP. It's not quite ActiveRecord, and the syntax of PHP ( namely "array(array("foo"=>"bar"))" ) gets in the way a bit, but it's not bad.
php  orm  database  webdevelopment 
january 2006 by infovore
SBook is Simson Garfinkel's Address Book
Interesting approach to search and data structure; ram it all in one field, AI-based search finds what you mean. Could be an interesting model.
search  database  handling 
december 2005 by infovore

Copy this bookmark: