4 month ago
deusx : Database design and CakePHP (Articles) | The Bakery, Everything CakePHP - "First of all you need to forget you are designing a database!" That, straight off, gives me the shakes.
# copy
7 month ago
mmb : http://tinydb.org/ - http://tinydb.org/ via programming: new: tinydb.org — similar to tinypic, but for chunks of XML / JSON data [via]
deusx : tinydb.org - "store some tiny data in a tiny url"
Andy Baio : TinyDB, store tiny data in a tiny URL - store variables with a POST or GET, get it back in JSON or XML [via]
# copy9 month ago
deusx : the ryan king » Introducing Conveyor - "The future for large websites’ data storage is likely a collection of special purpose data stores: GFS/MapReduce for batch jobs, inverted indexes for search and fast retrieval of small result sets and relational databases for smaller datasets whic
# copy
10 month ago
deusx : TagSchema - MySQLForge Wiki - Noticing one thing missing from most tagging schemes: Preservation of the order of tags as entered with the item. Seems minor, but it's actually important for capturing intent.
# copy
12 month ago
Simon Willison : Django Evolution - Django Evolution. Really smart take on the problem of updating database tables to reflect changes to Django models. Code that automatically modifies your database tables can be pretty scary, but Evolution seems to hit the right balance.
Rod Begbie : django-evolution - Google Code - Work-in-progress project to keep database schemas in sync with changes made to Django models. [via] #
# 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
17 month ago
deusx : Liminal Existence: SELECT * FROM everything, or why databases are awesome. - "Arg stabby stab stab stabbity fuck stab"
Simon Willison : SELECT * FROM everything, or why databases are awesome - SELECT * FROM everything, or why databases are awesome. I’m beginning to think that for scalable applications the thinner your ORM is the better—if you even use one at all.
# copy
19 month ago
jimray : Holovaty breaks down the new presidential candidate tracker at the Post - Great feature set, pretty much exactly what you'd expect from that crew
# copy
19 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
20 month ago
Jeremy Zawodny : MySQL Interface to Amazon S3 - MySQL Interface to Amazon S3: that totall kicks ass! I hope someone presents this at the MySQL Conference
joshua : MySQL Interface to Amazon S3
Andy Baio : MySQL interface to Amazon S3 - freaky cool hack [via]
deusx : Amazon Web Services Blog: MySQL Interface to Amazon S3 - "Independent developer Mark Atwood has been working on a MySQL interface to Amazon S3."
# copy
23 month ago
jimray : Google Base - Bulk Upload Instructions - XML format for uploading stuff in to GBase
# copy24 month ago
deusx : ITworld.com - A rush of codd to the hand - "Some of the best managed content I have ever seen sits on a Unix file system and some of the worst managed content I have ever seen sits in a big honking, breathtakingly expensive, relational database."
# copy
29 month ago
wearehugh : ongoing · No Database!?
jcgregorio : ongoing · No Database!? - "But there is a psychology out there in our profession,which says: if you have data that you want to store and retrieve, that means you need a database. But sometimes you don’t."
# copy
30 month ago
wearehugh : File Locking And Concurrency In SQLite Version 3
# copy
31 month ago
jimray : O'Reilly Radar > database - Interesting database design behind-the-scenes
# copy
35 month ago
kayodeok : Data Mining 101: Finding Subversives with Amazon Wishlists - Few things tell you as much about a person as the books he chooses to read. Isn't that why the Patriot Act specifically requires libraries to release information on who's reading what? For this reason, I chose to focus on the information contained in the
deusx : Data Mining 101: Finding Subversives with Amazon Wishlists | Applefritter - "Today, it is increasingly easy to monitor ideas. And then track them back to people."
# copy
37 month ago
jimray : The Joy of Migrations - Pretty well answers my "develop on SQLite locally, deploy on MySQL globally" question
# copy
37 month ago
jimray : SQLite Database Browser - Cross platform SQLite viewer - sweet
Paul Hammond : SQLite Database Browser - visual tool used to create, design and edit database files compatible with SQLite
# copy
39 month ago
kayodeok : Database Simplicity - XML - I would like to introduce ConvertRStoXML(). This function takes a recordset and converts it into a simple XML document
# copy
41 month ago
deusx : PostgreSQL and XML updated - "The XML functions for PostgreSQL (introduced here) have been updated and, as of version 8, ship with the standard distribution of PostgreSQL." XSLT and XPath in the database.
# copy
41 month ago
deusx : jclark.org : HOWTO: Build DB XML 2.0 with Python Bindings on OS X - "Here's what I did to build and install DB XML 2.0 along with python bindings on OS X 10.3.7." Wow, this has gotten a *lot* easier.
# copy
42 month ago
kayodeok : ONLamp.com: Top Ten Data Crunching Tips and Tricks - Top Ten Data Crunching Tips and Tricks
Matthew M. Boedicker : top ten data crunching tips and tricks
# copy
43 month ago
deusx : Rethinking the relational database | Perspectives | CNET News.com - "Ironically, a technology previously destined for the history books may well fit current and future requirements perfectly: the flat file." Er... since when were flat files going away?
# copy
43 month ago
kayodeok : Mysql vs postgres - The comparison of the newest, stable and production version of PostgreSQL 8.0 and MySQL 4.1 (MySQL has also development version 5.0)
# copy
44 month ago
kayodeok : Rootkiting Your Database - "If a database is a kind of operating system it should be possible to migrate operating system malware (like rootkits or viruses) to the database world. The following linked paper will try to explain how this migration can be done"
# copy
