Zeoslib Portal

Alternative is to use threaded splash screen
https://stackoverflow.com/questions/388 ... 2#45465592

marsupilami wrote: ↑27.05.2022, 15:14If somebody wants to provide a working implementation for Zeos, I will gladly accept it because it allows zeos to be used in an even wider range of use cases than before. Isn't that what OSS is about?

THAT'S the point!! The key words here are "if wants to provide".

Unless you operate the polygon points from SQL, that polygon for database is just a single entity "polygon". So the only difference from, say, varbinary is a little bit shorter code at the client-side.

stoffman wrote: ↑30.04.2022, 09:44As I've seen many cases of these none trivial types.

I'm not claiming to be absolutely right in any way. Would be nice if you provide some samples of array fields in real world

@marsupilami: I personally see no sense in working on a half-dead feature... Honestly I have little exp with real DBs designed by someone else but I've never seen array fields mentioned in FB's forum topics. Moreover, easy array API could do a bad service to users hiding expensive BLOB operations. J...

According to https://firebirdsql.org/file/documentation/pdf/en/refdocs/fblangref25/firebird-25-language-reference.pdf there's some support of arrays in FB but they're based on BLOBS anyway and mainly make sense if used in SQL. From what FB devs have said, nobody cares about supporting them in client...

Side note: don't you get upset by typing all these giantic AddScenarioMenu.AddScenarioCategoryListTree.Selected.Parent.Text-like identifiers?

I didn't check this myself but as far as I know, there is no possiblity to mark a connection as read only in Firebird. A read only connection (or transaction) in Firebird is a transaction where you didn't write yet. Some ressources on the server get assigned when the first write operation is done. ...

Hmm, doesn't the issue come from the fact that in Zeos connection and transaction are united? At least in Firebird the whole connection could be RO so as any transaction could (obviously if connection is RO, no RW tx is allowed). Of course the flag must be set before connect or tx starts.

Jan: How does this work and which drivers are supported Egonhugeist?
Jan: Ask Egonhugeist how this is infl uenced and which drivers work this
way.

Is FreeTDS thread safe? Different threads may all use separate connections without interfering with each other. Threads may not share a DBPROCESS or CS_CONNECTION without controlling access via a mutex. So - to support async operations reliably there must be a flag in connection object that rejects...

marsupilami wrote: ↑28.07.2021, 10:27 One use case

Well, how many interactive SQL apps are being written today in Delphi+Zeos? This use case is tooooo rare for me. And it's easily solved by storing parameters in separate list.

Glad to see you too :) Here's the catch. My workers which .Open or .Refresh a dataset always call .FetchAll right after. The reason behind is internally Zeos fetches all records at multiple places (e.g. .RecordCount) so without it my worker finished in 2 sec but the application was frozen for 20 :D ...

Oh, wow... does a salary raise come with the promotion too? :D Sure, you get +50% of your previous amount :D Well, my opinion is that any class is responsible for keeping its internal state consistency. Good example is TStringList: Sorted property not only changes a field, it sorts all items and ke...

AFAIU FireDAC from Delphi's std lib supports async, some ideas could be borrowed there. However, any semi-async implementation (as we know, there's no native language support of async operations) could be a problem source instead of a handy tool if a user is not doing it right. F.ex.: Dataset.OpenAs...