A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.
I'm thinking to do something like google base for fun-sake and to make a database for anything-under-the-sun that interest me in private.
Google base is interesting because it lets the user to define an item's data structure on the fly. But how is this implemented ?
- Do they store the data in a database or just in an XML data ?
- If it's XML, do these XML stored in database ?
- If it's XML, how does the searching work ?
Before you ponder this further, get your ideas flowing by watching the DabbleDB video demo: http://www.dabbledb.com/
Once I watched this, I immediately wanting to build a CSV to MySQL convertor in PHP (my chosen language). I just love how you take that data from a textarea and Bang!- some funky code makes it into columns and rows automagically. Something along the lines of splitting on commas and new lines. You could generate the same thing yourself with a simple web form with the following fields:
Fields Terminated By:
Fields Enclosed By:
Fields Escaped By:
Lines Terminated By:
CSV Data to be Converted:
Then with the input you just run it through some split()s and untainting (in front of the user so they can refine it) and Boom!
(I'm in no way affiliated with the Dabble dudes and dudettes.)
Wednesday, June 07, 2006
I love this. It works so well with the EAV thing I've been working on. Thanks for sharing dabble with me coz I didn't know it before!
Sunday, June 11, 2006
This topic is archived. No further replies will be accepted.Other recent topics
Powered by FogBugz