 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
marek jedlinski
Guest
|
 Posted: Thu Apr 20, 2006 6:04 pm Post subject: Talking to MySQL server (local and remote) |
 |
|
I've never done any work at all with database applications, though I have
some basic understanding of mysql (mostly by way of CMS systems). I need to
create a simple application for my personal use that will let me store
chunks of text along with some metadata in a mysql DB. I don't want to use
BDE and am using Delphi 6, so no .Net.
I'd like to start with a free or an inexpensive commercial solution, since
at this point it's only an experiment (I want to see if it will work better
than any non-DB solutions I've tried). I'm running MySQL 12.21 locally at
the moment, and can of course install a newer version if required. The
reason to use MySQL is that the DB will be portable and easy to transfer:
if the setup works well, I will eventually put it on a remote server
instead. (Can't use Firebird, since my hosting provider doesn't support
it.) I will also want to develop a PHP interface to the DB, though data
entry will be done via the Delphi application, mostly.
What are my options, please?
(I've looked at existing CMS systems, but they're much too complex for my
needs, and at the same time my app will need some simple but specialized
functionality which those systems do not have. And I want to learn about
using databases with delphi, so I'd like to roll something of my own.)
..marek
--
No ads, no nags freeware: http://www.tranglos.com
"If you're happy and you know it, clunk your chains." |
|
| Back to top |
|
 |
Kevin Powick
Guest
|
| Posted: Thu Apr 20, 2006 7:03 pm Post subject: Re: Talking to MySQL server (local and remote) |
|
|
marek jedlinski wrote:
| Quote: | I don't want to use BDE and am using Delphi 6, so no .Net.
I'd like to start with a free or an inexpensive commercial solution
|
Two free data access compoents for Delphi/MySQL that I know of are:
AnyDAC
http://www.da-soft.com
ZeosLib
http://sourceforge.net/projects/zeoslib/
An excellent, inexpensive commerical set of components are available
from Core Lab.
http://crlab.com/mydac/
| Quote: | I'm running MySQL
12.21 locally at the moment
|
The latest version of MySQL is 5.0, so I'm not sure where you got 12.21.
--
Kevin Powick |
|
| Back to top |
|
|
marek jedlinski
Guest
|
| Posted: Fri Apr 21, 2006 1:03 am Post subject: Re: Talking to MySQL server (local and remote) |
|
|
On 20 Apr 2006 11:19:00 -0700, "Kevin Powick" <nospam (AT) spamless (DOT) com> wrote:
Thank you. I seem to recall Zeos uses BDE, but I've tried AnyDAC. After
some trouble installing it (automated installers almost never work
correctly without tweaking, in my experience) I must say I'm overwhelmed. I
don't know where to begin, at all.
I recall trying a library once that used libmysql.dll, but it wouldn't work
with my version of MySQL. Is this generally better/worse for simple setups?
(I won't be using any advanced SQL features, I just need a place to dump
biggish chunks of text and retrieve them, after which I'll be applying my
own search routines and other processing.)
I'm also trying mysqldirect from sourceforge. It works out of the box and
is simple enough to use, now I "only" need to learn SQL commands and data
types. (Do I pass everything as a string? What about dates? Wrong group, I
know ;)
| Quote: |
I'm running MySQL
12.21 locally at the moment
The latest version of MySQL is 5.0, so I'm not sure where you got 12.21.
|
Shows how much I know  MySQL --version says " Ver 12.21 Distrib 4.0.14,
for Win95/Win98 (i32)", but you are of course right, 4.04 is the "official"
version designation.
..marek
--
No ads, no nags freeware: http://www.tranglos.com
** Google Sibel Edmonds **
"Mere factual innocence is no reason not to carry out a death
sentence properly reached." -- US Supreme Court Justice Antonin
Scalia, 1993 |
|
| Back to top |
|
|
Kevin Powick
Guest
|
| Posted: Fri Apr 21, 2006 2:04 am Post subject: Re: Talking to MySQL server (local and remote) |
|
|
marek jedlinski wrote:
| Quote: | On 20 Apr 2006 11:19:00 -0700, "Kevin Powick" <nospam (AT) spamless (DOT) com
wrote:
I seem to recall Zeos uses BDE
|
Really? I wouldn't think so because that would seem to defeat the
purpose, but I can't say for sure because I've never used it.
| Quote: | I've tried AnyDAC... I must say I'm
overwhelmed. I don't know where to begin, at all.
|
Sorry again, Haven't used it, but most data access componenets follow
the same sort of approach. A connection or database object to connect
to the server, then a table or query object to connect to the
connection/database object.
If you've never done it before and don't know the terminology, it can
be a little daunting.
| Quote: | I recall trying a library once that used libmysql.dll, but it
wouldn't work with my version of MySQL. Is this generally
better/worse for simple setups?
|
Some libs are direct connect and some use libmysql.dll. Of course
there is always the problem of compatibility when using libs that rely
on libmysql.dll, but you can run into this same problem with direct
access components if they don't support the particular version of MySQL
that you are using.
Personally, I prefer Core Labs MySQL DAC. It is direct connect, but
their latest version is usually compatible with the latest version of
MySQL, plus backwards compatible with older versions of MySQL.
| Quote: | I'm also trying mysqldirect from sourceforge. It works out of the box
and is simple enough to use, now I "only" need to learn SQL commands
and data types. (Do I pass everything as a string? What about dates?
Wrong group, I know 
|
I *think* the guy that wrote MySQLDirect also does work for the MySQL
components from MicroOLAP (forgot to mention them last time).
Not sure what you mean by "pass everything". MySQL supports data
typing just like Delphi. Yes, you need to visit another group to learn
SQL, but the MySQL documentation is quite good.
You can also poke around this site for some decent SQL info.
http://members.tripod.com/er4ebus/sql/index.htm
Good luck,
--
Kevin Powick |
|
| Back to top |
|
|
marek jedlinski
Guest
|
| Posted: Fri Apr 21, 2006 3:04 pm Post subject: Re: Talking to MySQL server (local and remote) |
|
|
On Fri, 21 Apr 2006 08:51:50 -0500, "Eug. C." <sundiskx (AT) NoSpamhotpop (DOT) com>
wrote:
| Quote: | Thank you. I seem to recall Zeos uses BDE, but I've tried AnyDAC. After
Zeos does not use BDE!
|
Sorry, it was my mistake. The homepage at http://zeosforum.net.ms/ was out
of service yesterday (still is, it seems) and I couldn't check to make
sure.
..marek
--
No ads, no nags freeware: http://www.tranglos.com |
|
| Back to top |
|
|
Eug. C.
Guest
|
| Posted: Fri Apr 21, 2006 3:04 pm Post subject: Re: Talking to MySQL server (local and remote) |
|
|
| Quote: | Thank you. I seem to recall Zeos uses BDE, but I've tried AnyDAC. After
Zeos does not use BDE! |
|
|
| Back to top |
|
|
Dmitry Arefiev [gs-soft.r
Guest
|
| Posted: Fri Apr 21, 2006 8:03 pm Post subject: Re: Talking to MySQL server (local and remote) |
|
|
Hello !
| Quote: | I must say I'm overwhelmed. I don't know where to begin, at all.
|
If you will appreciate my help, describe please
your issues and I will help you. Probably, better
will be to do that on my site conference.
Regards,
Dmitry
--
Dmitry Arefiev - www.da-soft.com
AnyDAC - Oracle, MySQL, MSSQL, MSAccess, IBM DB2, Sybase
ASA, DbExpress, ODBC freeware data access framework
gs-soft AG - www.gs-soft.com
SAPx - Delphi to SAP R/3 direct access
Saphir - SAP R/3 metadata at your fingertips
MetaBase - ERWIN model in Delphi applications |
|
| Back to top |
|
|
marek jedlinski
Guest
|
| Posted: Sat Apr 22, 2006 1:03 am Post subject: Re: Talking to MySQL server (local and remote) |
|
|
On Fri, 21 Apr 2006 22:43:16 +0400, "Dmitry Arefiev [gs-soft.ru]"
<darefiev@gs-soft.ru> wrote:
| Quote: | I must say I'm overwhelmed. I don't know where to begin, at all.
If you will appreciate my help, describe please
your issues and I will help you. Probably, better
will be to do that on my site conference.
|
Thank you, Dmitry, I'll post there.
..marek
--
No ads, no nags freeware: http://www.tranglos.com |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
