[fpc-pascal] Re: RE : RE : Re: SQLDB GetSchemaInfoSQL for indexes etc?

[michael.vancanneyt at wisa.be]

On Thu, 19 Apr 2012, Reinier Olislagers wrote:

>
> Proposal
> ========
> 1. As I'm interested in getting support for MS SQL Server and Sybase ASE
> into lazdatadesktop, I propose I'll go on with trying to make that work
> using the current sqldb structure. This will mean that a lot of code
> will go into new datadict fpddmssql.pp and fpddsybase.pp modules.
> I'll submit patches when done.
> 2. With that experience, I might have a better idea whether
> extending/changing sqldb with ISO information_schema could easily work
> for datadict.... however, I must say your argument re other db adapters
> does make a lot of sense.
>
> If so, I'll convert lazdatadesktop and the mssqlconn sqldb connector,
> breaking compatibility.
> Next, I'll convert Firebird sqldb to use the new approach.
> If those work and are acceptable, I can submit a patch for the other
> connectors (Oracle, PostgreSQL, mysql)... but will probably need some
> support for that.
>
> If not, I can try and adapt fpdatadict.pp and their dependents to use
> information_schema calls in e.g. ImportIndexes in order to make a
> default implementation for ISO compatible RDBMS... which non-compatible
> sqldb/dbf/zeos/whatever dbs will override...
> I will just ignore sqldb; perhaps provide a patch for mssqlconn to at
> least let it spit out similar info as Firebird.
>
> What do you guys think?

I expect your patches on Monday :-)

Seriously: please go ahead. If you need help, just mail me.

I'll be glad to see fpdatadict support more engines; 
Maybe it will gain wider acceptance, and the same then for the lazarus data
database desktop. I use it daily, but then, I use firebird...

Michael.