Great tool for sqlite but I think they've moved over to mySQL now.
Might be a ggod idea to prototype the app with SQLite (no/very little
db admin required) then port it over to mySQL if it turns out that
SQLite won;t do the job.
Pete Haworth
On Nov 23, 2010, at 2:10 PM, Andre Garzia wrote:
Jonathan,
If you use firefox, then pick up a firefox extension sqlite manager.
With
this extension you'll have a simple client able to work your
database files
which you can then later open and use in LiveCode.
There are other sqlite tools and yes you can do it by script but I
think it
is easier to use a graphical tool.
if you're on mac os x, then on the terminal there is a utility called
sqlite3 which can be used.
andre
On Tue, Nov 23, 2010 at 7:46 PM, Jonathan Lynch <jonathandly...@gmail.com
>wrote:
Honestly, I am still just trying to get my head around using
databases.
I use Rev for processing text in all sorts of creative ways at work -
vastly
increases our productivity - but, I know next to nothing about
database
use.
The logical process, to me, would be the following:
- Create database file
- Populate it with columns
- Set up my application to use an embedded database app to write and
retrieve data as needed
Say, for example, if I wanted to experiment with Valentina (knowing
that
the
demo version only lasts 10 minutes before the app has to be
restarted). I
could not fool around with it, without having an existing file to
work
with.
So, I thought to myself, my first step must be to create a database
file. I
am not committed to doing it in a script, I just don't know how
else to
access the embedded database driver functionalities.
Should I just find a blank database file somewhere on the web and
download
it?
On Tue, Nov 23, 2010 at 4:32 PM, Mark Schonewille <
m.schonewi...@economy-x-talk.com> wrote:
Jonathan,
That depends on the database you want to use. If you use MySQL
then the
answer is yes, although it might be possible to write new database
files
directly to the MySQL directory and restart MySQL (for which you
will
also
need to use the shell function).
Why are you so keen on creating a database file by script?
--
Best regards,
Mark Schonewille
Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553
How to receive a free Color Converter license http://qurl.tk/kv
(read
the
conditions)
On 23 nov 2010, at 22:24, Jonathan Lynch wrote:
Thanks, Mark.
I am not talking about a database on a server. I just want to
create a
database file on a shared drive. Would I still need to use a shell
command
for that?
_______________________________________________
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
--
Do all things with love
_______________________________________________
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
--
http://www.andregarzia.com All We Do Is Code.
_______________________________________________
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
