Valentina db

larry at significantplanet.org larry at significantplanet.org
Fri Oct 31 13:43:07 EDT 2014


Hi Bob,
Thanks for the detailed info.
I'll look into that.
Larry

----- Original Message ----- 
From: "Bob Sneidar" <bobsneidar at iotecdigital.com>
To: "How to use LiveCode" <use-livecode at lists.runrev.com>
Sent: Friday, October 31, 2014 9:06 AM
Subject: Re: Valentina db


> Hi Larry.
>
> The simplest SQL database to my mind is sqLite. You can create a database 
> by simply providing a path name and opening it using the LC built in 
> database functions. Once the file is created, you can download the Firefox 
> SQLite Manager plugin, open the database and begin to add tables and 
> columns.
>
> There are tons of easy to read tutorials on the inter web on how to do 
> select, insert and updates. The best source I think is sqlite.org itself 
> at https://www.sqlite.org/lang.html.
>
> sqLite is very forgiving when it comes to type constraints. This is 
> because the data is literally stored as text no matter what type the 
> column is. Where mySQL might throw an error for storing the wrong type of 
> data, sqLite will store whatever you tell it to.
>
> This is somewhat of a blessing, but also a curse. You really do want to 
> know if your data is outside the parameters you’ve set. However, for those 
> just starting out, it’s nice to not have to deal with SQL errors so much.
>
> Bob S
>
>
>> On Oct 30, 2014, at 24:42 , larry at significantplanet.org wrote:
>>
>> Hello,
>>
>> Has anyone used Valentina database with LC?
>>
>> If so, what is your experience with it?
>>
>> Is it a product that a newbie (me) could reasonably learn how to use with 
>> LC?
>>
>> Thanks for any info,
>> Larry
>>
>> P.S. If you have a recommendation for a database that is REALLY easy to 
>> use with LC, please let me know.
>> _______________________________________________
>> use-livecode mailing list
>> use-livecode at lists.runrev.com
>> Please visit this url to subscribe, unsubscribe and manage your 
>> subscription preferences:
>> http://lists.runrev.com/mailman/listinfo/use-livecode
>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your 
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode 





More information about the use-livecode mailing list