Thanks Bob, please send me the schema. Not sure what admin tool you're using but I think they all have a way of exporting the SQL statements to create the database.
Pete Molly's Revenge <http://www.mollysrevenge.com> On Fri, May 6, 2011 at 8:51 AM, Bob Sneidar <[email protected]> wrote: > Oh hey I have the perfect test. Spiceworks uses an SQLite database and it's > BIG. That will put it through it's paces!! > > Bob > > > On May 5, 2011, at 6:19 PM, Pete wrote: > > > Folks, > > A couple of months ago, I did a Livecode Live presentation on an LC > utility > > I'm working on that cuts out a lot of the coding work required to get SQL > > dbs working with LC. It's basically a library of behaviors and a couple > of > > front scripts that link groups/datagrids and controls/datagrid columns to > > SQL tables and columns/expressions. It automatically > > selects/updates/deletes/inserts data, figures out JOIN statements between > > tables, populates option menu/comboboxes, takes care of all the necessary > > conversion between SQL storage formats and LC display formats and > includes > > automatic filtering of SQL data in datagrids. My aim is to eliminate a > > large portion of the need to write SQL statements and the LC code to > manage > > SQL databases. > > > > Everything works quite nicely with the SQL dbs that I've designed but > before > > I put it our for beta, I'd really like to check it out against other SQL > dbs > > designed by other people - we all have our own ways of designing > databases > > and I want to make sure I've covered all the bases (no pun intended), or > at > > least the reasonable ones. > > > > Right now, this is SQLite only so I'm primarily interested in SQLite > schemas > > but I do plan on extending it to mySQL so schemas of that ilk would also > be > > welcome. If you have a schema you'd be prepared to send me for my own > > testing, please email me off list. I don't need any data from you, just > the > > CREATE statements that will allow me to create the tables, indexes, etc > so I > > can see what datatypes you use, how you set up primary keys, foreign > keys, > > indexes, db structural stuff of that nature.. > > > > Any help much appreciated, > > > > Pete > > Molly's Revenge <http://www.mollysrevenge.com> > > _______________________________________________ > > use-livecode mailing list > > [email protected] > > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > > http://lists.runrev.com/mailman/listinfo/use-livecode > > > _______________________________________________ > use-livecode mailing list > [email protected] > Please visit this url to subscribe, unsubscribe and manage your > subscription preferences: > http://lists.runrev.com/mailman/listinfo/use-livecode > > _______________________________________________ use-livecode mailing list [email protected] Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
