Can yoga do this

This is the place to post technical queries about SQL Yoga

Moderators: FourthWorld, heatherlaine, Klaus, robinmiller, trevordevore

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

Can yoga do this

Post by trevordevore » Fri Oct 11, 2013 1:40 pm

[This post is an archive from the old SQL Yoga forums]

I have a use case for sql_yoga where my son would like to create an app using sqlite to

keep up with his base ball card collection.

I was wondering about if sql_yoga would work for this type of instance.

here is an example of what the tables would look like,

Player Name card# Set name condition price

So there are five tables and as he adds cards to the database he would need to save the information and later

load that application back with the updated information.

so each time he adds a base ball card to his collection he would need to be able to enter that data and then save it.

Would this database option be able to handle this type of data and add records to the database files from a compiled desktop application.
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

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

Re: Can yoga do this

Post by trevordevore » Fri Oct 11, 2013 1:41 pm

Hi,

Yes, SQL Yoga could handle this quite nicely and wouldn't require that your son would have to learn any SQL. I am getting SQL Yoga ready for release and as part of that I am putting together a sample application that will show how to create an application that creates data in a SQLite database and then later retrieves it. When finished the manual for this app will be here:

http://revolution.screenstepslive.com/s ... _sampleapp
Trevor DeVore
ScreenSteps - https://www.screensteps.com

LiveCode Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode
LiveCode Builder Repos - https://github.com/search?q=user%3Atrevordevore+topic:livecode-builder

Post Reply

Return to “SQL Yoga”