Here is a snippet from your most recent post regarding MySQL:
Quote: "first of all, get Castlerustlers mysql dll (if he posts here and says i can, i'd like to host a perma link on one of my domains - redundancy )
Next you need the OBDC drivers - this is a connected, it allows the windows shell (like a ball where your db apps are inside, if you will) to "talk" to a MySQL Instance.
PHP has its own connector too, which runs in the PHP shell
(apps are run in shells because it allows them to be easily managed, like with php, after the script hits a certian execution time (normally 60 secs) the shell is closed - ending the script)
So i used the more modern (and will work with my function set) mysql connect, 5.1
MAKE SURE YOU GET THE RIGHT ONE FOR YOUR OS, I USE WINDOWS 7 x64 AND 32 BIT (x86) VERSIONS WILL NOT WORK ON IT
the connected can be found here:
http://dev.mysql.com/downloads/connector/odbc/5.1.html...
"
Your explanation takes about two pages on how to just get it set up.
ODBC, getting it connected, learning SQL... It's fine if needed. However, Dark Data is self-contained. No ODBC, no extra drivers, only it's library.
Indexing? It's fast. I have a friend who uses it for a list with about a million records, give-or-take. It hasn't been benchmarked but it looks practically instantaneous as well as giving that list in a particular order.
It uses a B-Tree system which is what most database systems use these days. ISAM we used to refer to (in my former company) as "Incredibly Slow Accessing Method" although it's probably been fine tuned in the past decade or so.
Quote: "with loads of thick books on it database system like "MySQL"
If you need loads of thick books too use something, it doesn't sound to easy to use does it?
I've used SQL and I like it. I do plan on creating one for this little thing. But as for why trying to reinvent the wheel? For the same reason that we went from one made of stone, reinvented to one made of wood, to one with spokes... all the way up to a steel belted radial.
It could also be said of Dark BASIC. Why reinvent BASIC? Why not just use C++? Go ahead and use OpenGL or OGRE or whatever else is free.
Simplicity. Some of us just want to get in there and do things, not worry about ODBC's and so-on.
Lastly, here is your statement in Dark Basic Pro with SQL:
mySQL_Init
conn$ = "DRIVER={MySQL ODBC 5.1 Driver};SERVER="+host$+";DATABASE="+base$+";UID="+user$+";PASSWORD="+pass$+";OPTION=3;"
con = mysql_setconnection(conn$)
row = mysql_runstatement("SELECT description from planet_list where name="" + planetname$ + """)
description$ = mysql_getrowdatabycolname(row, "description")
Here's DarkDATA's version:
KFS Open(1, "Planet.idx")
DFS Open(2, "Planet.dat")
record = KFS Find(1, planet$)
description = DFS Get(2, "description")
Sorry it's long winded but you asked me to extol the virtues. MySQL has it's place and I like it. It's just overkill for something like this.
Steele
