Hi Bob,
Thanks for the detailed info.
I'll look into that.
Larry
----- Original Message -----
From: "Bob Sneidar" <bobsnei...@iotecdigital.com>
To: "How to use LiveCode" <use-livecode@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 , la...@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@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@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
