Zeoslib Portal

miab3 wrote:http://zeoslib.sourceforge.net/viewtopi ... =3&t=40782

Michal

Is the 7.2 in a stable or final state now, and which commit number?

When I visit sourceforge to look at the repo there seem to be a lot of branches.

Which one should I download to get the latest version, and which commit shoud I check out?

Is it testing-7.2 or 7.3?

I am assuming 7.2 as 7.3 looks very new.

How can an in-memory SQLite database be saved to disk? Is there support for it in Zeoslib, or does it have to be coded separately? On checking StackOverflow I found this link http://www.sqlite.org/backup.html which uses the C-API. Does Zeoslib expose the necessary handles or variables which can allo...

What settings can I use to ensure that a Sqlite database opened in Zeoslib will not interfere with the ability of another process to read from it? I think that is something that should be set in the TZConnection properties. Is there some option or something in the parameters that will ensure that an...

I am using the TZConnection from Zeoslib and although I set the schema in the connection, when I run a query it seems to revert to the PUBLIC schema. Unless I prefix tablenames with the schema name like select schemaname.tablename from schema the queries don't work Are schemas properly supported by ...

Is there a way to set the timeout on a PostgreSQL query?

Is there some Params or other means of telling a query or a connection how long to wait before a query reports a time out? If its not possible at the level of the query can it be set on the connection level?

I was able to work out why. It appears that zeoslib inspects the database and when it realizes that the column is a serial, it increments the nextval and copies it into the field. but because my update query did not insert the serial field, expecting it to be set by the server, serial got incremente...

I am using ZQuery with ZUpdateSQL components and I realize that the serial autoincrement value is jumping up by 2 everytime. I suspect it may be due to some interaction between the ZQuery and PostgrSQL database.

I suspect it is an issue that has come before.

Any pointers?

/vfclists

Is there a way of testing when a TZConnection is active when the network is down? The TZConnection.Connected property is true even when the network connection is down, and it doesn't seem to change when an attempt to connect to the database fails. Isn't there a way of monitoring the TZConnection rat...

I have been getting errors trying to write to a SQLite database in quick succession. Reading the SQLite faq at http://www.sqlite.org/faq.html#q5 indicates that locking problems can be fixed by calls to sqlite3_busy_handler() and sqlite3_busy_timeout(). Is there support for this somewhere in the Zeos...

According to the sqlite docs sqlite3 treats booleans as integers 0 and 1, but zeoslib sends them as 'N' and 'Y'.

Is an update of the code for consistency called for in this respect?

When I try to run a program developed with Lazarus on windows I get an error that libpq.dll and libpq81.dll cannot be found. I downloaded the latest postgresql 8.4 to ensure the libraries would be present but it didn't work. So I extracted one from an older pgAdmin 3 installer. That works inside the...

Does ZeosDBO work with ClientDatasets? Does it have an IProvider interface?

I am not quite familiar with ClientDatasets, but can any Dataset component be used with a ClientDataset?

I saw the ZSequence component on the component lists and it works quite well with PostgreSQL.

I have had no problems with it so far.

When I attempt to add a new record to postgresql table in which the record id integer is generated by a sequence on the server, I get a value required error although the server will generate the value. Is there some way it can be disabled? TZQuery has a sequence property? Will setting it to the name...