Board index » delphi » Talking to MySQL server (local and remote)

2006-04-21 01:40:45 AM
delphi56
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 is only an experiment (I want to see if it will work better
than any non-DB solutions I have tried). I am 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 would like to roll something of my own.)
.marek
--
No ads, no nags freeware: www.tranglos.com
"If you're happy and you know it, clunk your chains."
 

marek jedlinski writes:
AnyDAC
www.da-soft.com
ZeosLib
sourceforge.net/projects/zeoslib/
An excellent, inexpensive commerical set of components are available
from Core Lab.
crlab.com/mydac/
--
Kevin Powick
 

On 20 Apr 2006 11:19:00 -0700, "Kevin Powick" <XXXX@XXXXX.COM>writes:
some trouble installing it (automated installers almost never work
correctly without tweaking, in my experience) I must say I am 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 will 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 ;)
for Win95/Win98 (i32)", but you are of course right, 4.04 is the "official"
version designation.
.marek
--
No ads, no nags freeware: 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
 

marek jedlinski writes:
purpose, but I can not say for sure because I have never used it.
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.
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.
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.
members.tripod.com/er4ebus/sql/index.htm
Good luck,
--
Kevin Powick
 

 

On Fri, 21 Apr 2006 08:51:50 -0500, "Eug. C." <XXXX@XXXXX.COM>
writes:
of service yesterday (still is, it seems) and I couldn't check to make
sure.
.marek
--
No ads, no nags freeware: www.tranglos.com
 

Hello !
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, MS SQL, 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
 

On Fri, 21 Apr 2006 22:43:16 +0400, "Dmitry Arefiev [gs-soft.ru]"
<XXXX@XXXXX.COM>writes:
.marek
--
No ads, no nags freeware: www.tranglos.com