1. ODBC and MySQL (George)
George, how is the MySQL integration/interfacing going? Is it pretty simple
(as simple as, say, working with a EUPHORIA database)? I'm curious because I
might need an industrial strength db app in the near future... Why are you
using MySQL?
2. Re: ODBC and MySQL (George)
I'm just getting started. I chose it because it is free and I didn't want to
spend money just to see if it would all work with EU. I also wanted a tool
that had data recovery, record (row) locking. So far I've written a program
to create the data base, all the tables and cols for an A/R module. That was
easy. The only hard(not hard just tedious) part was constructing the sql
statements to create the tables for all the "files". Now I'm starting to
think about exporting the data files from EUDb to MySQL as a starter, which
is where this Date issue arose.
george
----- Original Message -----
From: "C. K. Lester" <euphoric at cklester.com>
To: "EUforum" <EUforum at topica.com>
Sent: Monday, September 29, 2003 11:34 AM
Subject: ODBC and MySQL (George)
>
>
> George, how is the MySQL integration/interfacing going? Is it pretty
simple
> (as simple as, say, working with a EUPHORIA database)? I'm curious because
I
> might need an industrial strength db app in the near future... Why are you
> using MySQL?
>
>
>
> TOPICA - Start your own email discussion group. FREE!
>
>
3. Re: ODBC and MySQL (George)
> I'm just getting started. I chose it because it is free and I didn't want
to
> spend money just to see if it would all work with EU. I also wanted a tool
> that had data recovery, record (row) locking. So far I've written a
program
> to create the data base, all the tables and cols for an A/R module. That
was
> easy. The only hard (not hard just tedious) part was constructing the sql
> statements to create the tables for all the "files".
Can you post some sample code, or send it to me privately?
> Now I'm starting to
> think about exporting the data files from EUDb to MySQL as a starter,
which
> is where this Date issue arose.
Is it working pretty fast? I think MySQL is threaded, right? Would that
matter when working with the database via EUPHORIA? I'm guessing you could
start something up (a query) and keep doing other database operations while
that first one works and completes.
4. Re: ODBC and MySQL (George)
Another reason, I like the fact that the indexes, data, and tables in MySql
are all in separate files which would minimize any corruption damage. I am
using (and would probably continue) EUDb for writing and debugging. I have
all the I/O routines ( open, read, readnext, etc)isolated as includes so I
would only have to include a different library set for MySQL and the
software would continue to work as written. At least that's the plan.
george
----- Original Message -----
From: "C. K. Lester" <euphoric at cklester.com>
To: "EUforum" <EUforum at topica.com>
Sent: Monday, September 29, 2003 11:34 AM
Subject: ODBC and MySQL (George)
>
>
> George, how is the MySQL integration/interfacing going? Is it pretty
simple
> (as simple as, say, working with a EUPHORIA database)? I'm curious because
I
> might need an industrial strength db app in the near future... Why are you
> using MySQL?
>
>
>
> TOPICA - Start your own email discussion group. FREE!
>
>
5. Re: ODBC and MySQL (George)
I send you some attachments privately..
george
----- Original Message -----
From: "C. K. Lester" <euphoric at cklester.com>
To: "EUforum" <EUforum at topica.com>
Subject: Re: ODBC and MySQL (George)
>
>
> > I'm just getting started. I chose it because it is free and I didn't
want
> to
> > spend money just to see if it would all work with EU. I also wanted a
tool
> > that had data recovery, record (row) locking. So far I've written a
> program
> > to create the data base, all the tables and cols for an A/R module. That
> was
> > easy. The only hard (not hard just tedious) part was constructing the
sql
> > statements to create the tables for all the "files".
>
> Can you post some sample code, or send it to me privately?
>
> > Now I'm starting to
> > think about exporting the data files from EUDb to MySQL as a starter,
> which
> > is where this Date issue arose.
>
> Is it working pretty fast? I think MySQL is threaded, right? Would that
> matter when working with the database via EUPHORIA? I'm guessing you could
> start something up (a query) and keep doing other database operations
while
> that first one works and completes.
>
>
>
> TOPICA - Start your own email discussion group. FREE!
>
>
