LiveCode Forums

Developers are often required to work with DBMSs that they have little or no expertise in, and that is where db libraries like SQL Yoga really come handy. Many libraries, however, seem to expect that the tables in the database will already exist - or leave it up to the developer to create and modify them by some other means. That seems to me to defeat the purpose of the library.

While being able to do CRUD operations is crucial, the developer can get away with using basic, standard SQL for most of these queries - and the knowledge required of the underlying DBMS is negligible. Creating and editing tables and fields, however, does require the developer to know the nitty-gritty of how things work behind the scenes - which is what we want to avoid - like: what data types are supported, when are indexes needed, how to setup foreign keys, etc.

Does SQL Yoga provide a database-agnostic way of creating, altering and deleting tables (and defining fields)?

Check out SQLiteAdmin. It might be what you're looking for.

Thank you for the recommendation:

shawnblc wrote:Check out SQLiteAdmin. It might be what you're looking for.

If we are looking at developing the database with an external tool, then something which is database-agnostic is usually more useful - like this:

http://www.malcolmhardie.com/sqleditor/

I was crossing my fingers and hoping I wouldn't have to use an external tool at all, though...

The SQL Yoga update that I will release as the first dual licensed version will include some experimental code for automatically creating and then later updating database schemas.

trevordevore wrote:The SQL Yoga update that I will release as the first dual licensed version will include some experimental code for automatically creating and then later updating database schemas.

Awesome!!

Thank you for keeping us informed!