Create/Alter/Delete Tables?

This is the place to post technical queries about SQL Yoga

Moderators: heatherlaine, Klaus, FourthWorld, robinmiller, trevordevore

Post Reply
icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 76
Joined: Wed May 29, 2013 1:54 am
Location: Sydney, Australia

Create/Alter/Delete Tables?

Post by icouto » Fri Oct 11, 2013 11:48 pm

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)?

shawnblc
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 311
Joined: Fri Jun 01, 2012 11:11 pm
Location: USA

Re: Create/Alter/Delete Tables?

Post by shawnblc » Sat Oct 12, 2013 2:07 am

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

icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 76
Joined: Wed May 29, 2013 1:54 am
Location: Sydney, Australia

Re: Create/Alter/Delete Tables?

Post by icouto » Sat Oct 12, 2013 9:13 am

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...

trevordevore
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 853
Joined: Sat Apr 08, 2006 3:06 pm
Location: Overland Park, Kansas
Contact:

Re: Create/Alter/Delete Tables?

Post by trevordevore » Sat Oct 12, 2013 8:48 pm

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.
Trevor DeVore
ScreenSteps - http://www.screensteps.com

Levure Application Framework: https://github.com/trevordevore/levure
LiveCode Resources for Developers: http://livecode.bluemangolearning.com

icouto
VIP Livecode Opensource Backer
VIP Livecode Opensource Backer
Posts: 76
Joined: Wed May 29, 2013 1:54 am
Location: Sydney, Australia

Re: Create/Alter/Delete Tables?

Post by icouto » Sat Oct 12, 2013 9:25 pm

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!! :D

Thank you for keeping us informed!

Post Reply

Return to “SQL Yoga”