HTSQL — a database query language for the accidental programmer
march 2011 by avantbard
"HTSQL is a URI-based high-level query language for relational databases. HTSQL wraps your database with a web service layer, translating HTTP requests into SQL and returning results as HTML, JSON, etc.
HTSQL is designed for someone who is not a SQL expert, but needs a usable, comprehensive query tool for data access and reporting."
postgresql
postgres
database
reporting
sql
HTSQL is designed for someone who is not a SQL expert, but needs a usable, comprehensive query tool for data access and reporting."
march 2011 by avantbard
rubyphunk's reflection at master - GitHub
november 2009 by avantbard
"Reflection is designed to keep your development system in sync with your production system’s files and database (by dumping). It uses a shared git repository to store these files, which allows you to mirror your production environment without the need of direct access to your production servers."
git
production
development
dev
database
deployment
mirroring
mirror
november 2009 by avantbard
eladmeidar's rails_indexes at master - GitHub
september 2009 by avantbard
Rake task to help you find places where you probably need db indexes in your rails app, and to generate a migration to easily add those indexes.
rails
db
database
index
indexes
rake
september 2009 by avantbard
mokolabs's legacy at master - GitHub
september 2009 by avantbard
Seems like a great way to migrate legacy data from an old db into a new rails app's db. From the talk: http://github.com/mokolabs/legacy/tree/master
rails
db
migrate
migration
legacy
database
sd.rb
september 2009 by avantbard
up and running with cassandra
july 2009 by avantbard
"Cassandra is a hybrid non-relational database in the same class as Google's BigTable. It is more featureful than a key/value store like Dynomite, but supports fewer query types than a document store like MongoDB."
cassandra
bigtable
database
db
twitter
data
distributed
scaling
scalability
document
facebook
ruby
july 2009 by avantbard
adamwiggins's yaml_db
february 2009 by avantbard
rails plugin to dump db data yo yaml
yaml
rails
rubyonrails
webdev
database
db
plugin
plugins
february 2009 by avantbard
query_reviewer
february 2009 by avantbard
"This rails plugin not only runs "EXPLAIN" before each of your select queries in development, but provides a small DIV in the rendered output of each page with the summary of query warnings that it analyzed."
rails
rubyonrails
webdev
sql
query
plugin
plugins
database
db
optimization
february 2009 by avantbard
related tags
api ⊕ bigtable ⊕ cassandra ⊕ data ⊕ database ⊖ db ⊕ debugging ⊕ deployment ⊕ dev ⊕ development ⊕ distributed ⊕ document ⊕ dtrace ⊕ facebook ⊕ gem ⊕ git ⊕ graph ⊕ hierarchicaldata ⊕ html5 ⊕ index ⊕ indexes ⊕ javascript ⊕ js ⊕ key ⊕ key-value ⊕ keyvalue ⊕ legacy ⊕ mac ⊕ migrate ⊕ migration ⊕ mirror ⊕ mirroring ⊕ mongodb ⊕ mysql ⊕ nosql ⊕ optimization ⊕ orm ⊕ performance ⊕ plugin ⊕ plugins ⊕ postgres ⊕ postgresql ⊕ production ⊕ query ⊕ rails ⊕ rake ⊕ reporting ⊕ ruby ⊕ rubyonrails ⊕ scalability ⊕ scaling ⊕ sd.rb ⊕ sql ⊕ storage ⊕ tools ⊕ tuning ⊕ twitter ⊕ value ⊕ webdev ⊕ yaml ⊕Copy this bookmark: