1. ODBC and MySQL (George)
- Posted by "C. K. Lester" <euphoric at cklester.com> Sep 29, 2003
- 464 views
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)
- Posted by George Walters <gwalters at sc.rr.com> Sep 29, 2003
- 433 views
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)
- Posted by "C. K. Lester" <euphoric at cklester.com> Sep 29, 2003
- 420 views
> 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)
- Posted by George Walters <gwalters at sc.rr.com> Sep 29, 2003
- 407 views
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)
- Posted by George Walters <gwalters at sc.rr.com> Sep 29, 2003
- 420 views
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! > >