Zeoslib Portal

If you use PostgreSQL and Domains there is a regression from 6.1.5. I have put a patch on Sourceforge.

Regards,

Ben

I'd say better alternatives are Postgresql or Firebird as they don't have limitations or licencing problems.

Regards,

Ben

I wasn't very clear in what I said and maybe my logic was a bit off but to clarify my point, in the case of MySQL do you see the following as correct? To use MySQL with a commercial application all you need to do is create an interface to the client library in one of the allowed licences and then ac...

Does that mean I can make a simple FOSS interface to whatever GPL software I want and then use it within a commercial application? IANAL so I don't know, but it doesn't seem to be what MySQL are aiming for.

All these different licences make this kind of area a minefield.

Ben

It puts my mind at rest that you are also using ZeosLib with lots of threads. I thought it was just me!

Currently everything is working without the ZSQLMonitor so I'll just leave it at that till I have more time to look into things.

Regards,

Ben

Nothing like that. It just had a seperate ZSQLMonitor and log file for each thread and then set AutoSave and Active to true.

Looking at the ZeosLib source I'm not sure what is the best way to go forward with this. Currently I can do without the logging but it would be useful in the future.

Ben

BTW PostgreSQL is BSD - No worries there.

Ben

There has been loads of discussion on this point and it's in the MySQL faq (see http://www.mysql.com/company/legal/licensing/faq.html). There is an exception for PHP but I think I'm right in what I said. I suppose MySql are trying to push people to pay for their commercial licence.

Ben

I was using ZSQLMonitor on a per thread basis. Every so often I would get a AV due to the above. I've removed the ZSQLMonitor from the newest version of our app and haven't had any problem since. I can see in the source that DriverManager is used in a few other places but can't see they will be a pr...

I've just been having some problems running ZeosLib in a threaded application. It is mainly related to using the ZSQLMonitor component. There is a global variable declared in ZDbcIntfs.pas: var {** The common driver manager object. } DriverManager: IZDriverManager; that is then used throughout the b...

What is the licence of the client library of MySQL 5?

I thought it was GPL which makes it problematic to use with something like ZeosLib, which as I understand it is 'LGPL with exceptions'.

Regards,

Ben

I'd like to clarify that: INSERT INTO table_name (table_name.field_name) VALUES ('Test value'); is not compatible with PostgreSQL. It needs to be: INSERT INTO table_name (field_name) VALUES ('Test value'); I've tested the above with 8.0.x and 8.1.x. I agree that the above patch looks the wrong way t...

You can try downloading the cvs. I think it's been updated to work with Delphi 2006. See in the 6.5.1 forum for some discussion.

Ben

IIRC this has been mentioned before somewhere on this (or the previous) forum. It seems to be a MySql thing relating to the client dll. It might be worth having a look on the MySql forums for a fix.

Ben

See SortedFields property.

Regards,

BTW TZTable components and their like are just plain bad! Best to use TZQuery and select only the fields you want.

Ben