Firebird External Table Generator (ext-table-gen) version 1.0 released

[Mark Rotteveel]

I just released Firebird External Table Generator (ext-table-gen), version 1.0.

This is a Java-based commandline tool to transform RFC 4180 CSV files to Firebird external table files. The initial version only supports CHAR columns, but I plan to add support for datetime types and exact numeric types (with appropriate formats/conversions); not yet sure about other types.

For more information:

• Release v1.0 downloads
• Release notes
• Documentation
  
• GitHub project

Questions and feedback can be posted in https://github.com/mrotteveel/ext-table-gen/discussions. Bugs can be reported in https://github.com/mrotteveel/ext-table-gen/issues.

Mark

-- 
Mark Rotteveel

[Dalton Calford]

It would be wonderful if an external engine Y-connector was possible such as mariadb's connect table engine
ie 
CREATE TABLE `PW-DATASQL10`.test_clicks_botstage
ENGINE=CONNECT,
TABLE_TYPE='ODBC',TABNAME='eye.test_clicks_botstage',
CONNECTION='Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.2.so.2.1;Encrypt=No;Server=servername;Database=mydatabase;UID=username;PWD=password';

This would allow for connecting to remote servers, remote databases etc for dataporting or legacy system support.
But, we don't even have support for recursive schema such as oracle which has been a request since interbase 6.   

--
You received this message because you are subscribed to the Google Groups "firebird-general" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-gener...@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-general/afa5289f-6e9b-fded-34fe-e1620e7b1600%40lawinegevaar.nl.

[Dimitry Sibiryakov]

Dalton Calford wrote 28.06.2023 17:41:
> It would be wonderful if an external engine Y-connector was possible such as
> mariadb's connect table engine

Yes, it is impossible to create "remote" table and reference it in queries
but it is possible to access tables in remote databases from PSQL using ESonEDS.
With a custom engine provider it is possible even to use heterogeneous data
sources such as ODBC (http://www.ibphoenix.com/products/software/magpie).

--
WBR, SD.

[Dalton Calford]

Wow, that is new.   Glad to see it.   
With selectable stored procedures/views/update triggers etc., you could make it work as a package.

But, it would be easier as a direct link without needing to create all that overhead.

--
You received this message because you are subscribed to the Google Groups "firebird-general" group.
To unsubscribe from this group and stop receiving emails from it, send an email to firebird-gener...@googlegroups.com.

To view this discussion on the web, visit https://groups.google.com/d/msgid/firebird-general/3505d84a-80ff-cd99-6da4-9ab8309ab903%40ibphoenix.com.

[Mark Rotteveel]

On 28-06-2023 17:41, Dalton Calford wrote:
> It would be wonderful if an external engine Y-connector was possible
> such as mariadb's connect table engine
> ie
> CREATE TABLE `PW-DATASQL10`.test_clicks_botstage
> ENGINE=CONNECT,
> TABLE_TYPE='ODBC',TABNAME='eye.test_clicks_botstage',
> CONNECTION='Driver=/opt/microsoft/msodbcsql18/lib64/libmsodbcsql-18.2.so.2.1;Encrypt=No;Server=servername;Database=mydatabase;UID=username;PWD=password';
>
> This would allow for connecting to remote servers, remote databases etc
> for dataporting or legacy system support.
> But, we don't even have support for recursive schema such as oracle
> which has been a request since interbase 6.

I would already be happy for support for reading/writing CSV (and thus
entirely removing the raison d'être for ext-table-gen :)

Mark
--
Mark Rotteveel

[Dimitry Sibiryakov]

Mark Rotteveel wrote 28.06.2023 18:04:
> I would already be happy for support for reading/writing CSV (and thus entirely
> removing the raison d'être for ext-table-gen :)

There is Microsoft ODBC driver for CVS.

--
WBR, SD.

[Mark Rotteveel]

I was more thinking of built-in in Firebird itself.

Mark
--
Mark Rotteveel