14 days ago
deusx : The Phrasebook Pattern - Not unlike templates for (X)HTML? "The Phrasebook pattern is a technique to separate expressions in one language (e.g., SQL) from the main code that is written in another programming language (e.g., Perl). This is done by keeping the expressions in a
# copy
7 month ago
joshua : DB2 Express-C: the best things in life are free! - IBM's competitor for mysql?
# copy
8 month ago
joshua : innodb 1.0 for mysql 5.1 - ooh... fast index creation, gimme
# copy
9 month ago
wearehugh : Big DBA Head! - Database Brain Power! » A Few Common Performance Mistakes - sql programmers are so cute
# copy
11 month ago
deusx : Storing Hierarchical Data in a Database [PHP & MySQL Tutorials] - "There are two major approaches: the adjacency list model, and the modified preorder tree traversal algorithm. In this article, we'll explore these two methods of saving hierarchical data."
# copy
14 month ago
Simon Willison : A Visual Explanation of SQL Joins - A Visual Explanation of SQL Joins. It turns out Venn diagrams are an excellent way of illustrating joins.
Matthew M. Boedicker : better Venn diagrams of SQL joins - (via del.icio.us/popular) [via]
43folders : Coding Horror: A Visual Explanation of SQL Joins
philgyford : Coding Horror: A Visual Explanation of SQL Joins - SQL joins as Venn diagrams (but better than the previous post on SQL joins as Venn diagrams that I read). (via Infovore)
# copy
14 month ago
Rod Begbie : xkcd - Exploits of a Mom - "Did you really name your son "Robert'); DROP TABLE Students;--" ?" #
# copy
15 month ago
nelson : MySQL replication practice - Great blog entry about reliable snapshots, repliation delay, etc
# copy
20 month ago
deusx : Twitter, Rails, Hammers, and 11,000 Nails per Second — Thought Palace - "And of course you could keep going with this novel “distributed” idea, and make this into an actually-distributed system, where individual users (or groups of them) can run their own Twitter servers that queue their incoming messages and relay t
# copy
21 month ago
joshua : Sphinx - fulltext indexing with mysql integration
Jeremy Zawodny : Sphinx - Sphinx: Free open-source SQL full-text search engine with decent MySQL integration.
# copy
22 month ago
Simon Willison : Facebook Query Language - Facebook Query Language. The Facebook API now lets you run SQL-like queries. You can’t do joins but you can perform very simple subselects.
cameron : Facebook Query Language - Facebook allows for FQL queries, SQL-style requests to their API data. Very cool.
deusx : Facebook Developers | Facebook Query Language - "FQL is a way to query the same Facebook data you can access through the other API functions, but with a SQL-style interface."
# copy
26 month ago
Jeremy Zawodny : MySQL Tips - MySQL Tips: a big text file full of MySQL tips
joshua : MySQL Tips - a bunch of deep wizardry
Matthew M. Boedicker : MySQL tricks - even line art and geometry (via del.icio.us/joshua) [via]
# copy
28 month ago
jcgregorio : SQLAlchemy - The Database Toolkit for Python - Both this and SQLObject look pretty mature. Expect some hands on time with both of them in the near future.
# copy28 month ago
jcgregorio : SQLObject - "SQLObject is a popular Object Relational Manager" Not object persistence. Object persistence is wrong. This is not object persistence. In Python.
# copy
28 month ago
Simon Willison : MySQL: Get total number of rows when using LIMIT - Useful tip. [via]
bmilleare : MySQL: Get total number of rows when using LIMIT
Paul Hammond : AS Workshop » MySQL: Get total number of rows when using LIMIT - since MySQL 4.0.0 you can use SQL_CALC_FOUND_ROWS option in your query which will tell MySQL to count total number of rows disregarding LIMIT clause
# copy
28 month ago
wearehugh : The Blog Ride - The Vietnam of Computer Science
jimray : The Blog Ride - The Vietnam of Computer Science - "Object/Relational Mapping is the Vietnam of Computer Science."
# copy
29 month ago
Paul Hammond : The B-List: JavaScript, ORM and "hiding SQL" - you’re a web developer and it’s your job to know this stuff, so learn it already
deusx : The B-List: JavaScript, ORM and "hiding SQL" - 'having ORM isn't "hiding SQL".'
# copy
32 month ago
wearehugh : The Inner-Platform Effect - The Daily WTF
# copy
32 month ago
Jeremy Zawodny : SQL on Rails - SQL on Rails: watch the screencast. be amused. be very amused.
deusx : SQL on Rails - "Rails is a short-stack framework for developing database-contained web applications according to the Model-Model-Model pattern."
# copy
33 month ago
Rod Begbie : Daversy - "Daversy is a source control tool for relational databases." Man, something like this has been needed for years. [via] #
joshua : daversy.tigris.org - Daversy is a source control tool for relational databases.
# copy
36 month ago
jimray : Store apache logs in SQL database with mod_log_sql - This could make a really quick and dirty stats app with less fuss
Nelson Minar : Apache mod_log_sql - Log web server hits to a database. Pain to set up, but seems to work.
# copy
38 month ago
jimray : The Joy of Migrations - Pretty well answers my "develop on SQLite locally, deploy on MySQL globally" question
# copy
38 month ago
jimray : A Quick Guide to SQLite and Ruby - I'm curious about the feasability of developing RoR apps using SQLite locally and then migrating to MySQL or Postgres in production
# copy
39 month ago
kayodeok : PostgreSQL SQL Syntax and Use - This chapter covers the basic operation of PostgreSQL, including naming conventions, creating a database, and indexing. When you finish with it, you should be able to use PostgreSQL for most basic functions
# copy
