tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Alain De Vos]

In our modern time there are also modern databases.
But for connecting one needs a connector.
I wander to which databases I can connect with ada.

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Alain De Vos]

On Thursday, October 31, 2019 at 6:18:01 PM UTC+1, Alain De Vos wrote:
> In our modern time there are also modern databases.
> But for connecting one needs a connector.
> I wander to which databases I can connect with ada.

Well if I can connect to python I might have a very ugly-workaround.
But how do I connect to python ?

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Dennis Lee Bieber]

On Thu, 31 Oct 2019 16:32:13 -0700 (PDT), Alain De Vos
<devosalain71@gmail.com> declaimed the following:

>On Thursday, October 31, 2019 at 6:18:01 PM UTC+1, Alain De Vos wrote:
>> In our modern time there are also modern databases.
>> But for connecting one needs a connector.
>> I wander to which databases I can connect with ada.
>
>Well if I can connect to python I might have a very ugly-workaround.
>But how do I connect to python ?

	Since Python is a (byte-code) interpreted programming language in its
own right, you could design some interprocess communication protocol, write
handlers for said protocol in Ada and Python, and run the Python stuff in a
separate process.

	Or, you study the section of the Python manual regarding embedding the
language in another application -- and write an interface layer in Ada to
access the embedded mode API (which is documented for C language
programming, so your interface layer is going to look a lot like a binding
to any other C-language library):
https://docs.python.org/3/extending/embedding.html

	Of course, you'll need the proper db-api adapter for Python to use
whatever DBMS you are targeting.



-- 
	Wulfraed                 Dennis Lee Bieber         AF6VN
	wlfraed@ix.netcom.com    http://wlfraed.microdiversity.freeddns.org/

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Dmitry A. Kazakov]

On 2019-11-01 00:32, Alain De Vos wrote:
> On Thursday, October 31, 2019 at 6:18:01 PM UTC+1, Alain De Vos wrote:
>> In our modern time there are also modern databases.
>> But for connecting one needs a connector.

If connector means DB client then this is wrong. Embeddable databases 
like tokyocabinet and SQLite need none, the DBMS is a part of your program.

>> I wander to which databases I can connect with ada.

All of them.

> Well if I can connect to python I might have a very ugly-workaround.
> But how do I connect to python ?

Python has appropriately ugly and buggy API. It is no problem to call 
Python from Ada. I have Ada applications running Python scripts.

-- 
Regards,
Dmitry A. Kazakov
http://www.dmitry-kazakov.de

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Shark8]

On Thursday, October 31, 2019 at 11:18:01 AM UTC-6, Alain De Vos wrote:
> In our modern time there are also modern databases.
> But for connecting one needs a connector.
> I wander to which databases I can connect with ada.

Apparently GNATCOLL has some database bindings, but I never got them to work. (64bit Windows, 32bit GNAT, 64bit Postgres was my setup back then IIRC; I suspect it had to do with the difference in 32- and 64-bit.)

I think Dmitry's Simple Components has a ODBC interface.

And there's an all-Ada graph-database called MNESON that I'm poking at to try to use Ada.Containers rather than the containers it's using.

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Alain De Vos]

On Friday, November 1, 2019 at 2:51:27 PM UTC+1, Shark8 wrote:
> On Thursday, October 31, 2019 at 11:18:01 AM UTC-6, Alain De Vos wrote:
> > In our modern time there are also modern databases.
> > But for connecting one needs a connector.
> > I wander to which databases I can connect with ada.
> 
> Apparently GNATCOLL has some database bindings, but I never got them to work. (64bit Windows, 32bit GNAT, 64bit Postgres was my setup back then IIRC; I suspect it had to do with the difference in 32- and 64-bit.)
> 
> I think Dmitry's Simple Components has a ODBC interface.
> 
> And there's an all-Ada graph-database called MNESON that I'm poking at to try to use Ada.Containers rather than the containers it's using.

gnatcoll has normally sqlite and postgres. 
But sqlite,postgres,mysql is the "usual stuff"

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Björn Lundin]

Den 2019-10-31 kl. 18:17, skrev Alain De Vos:
> In our modern time there are also modern databases.
> But for connecting one needs a connector.
> I wander to which databases I can connect with ada.
> 

https://jrmarino.github.io/AdaBase/introduction.html
(mysql,postgresql,sqlite)

others like ms sql-server -> ODBC

Oracle -> ODBC or native OCI.
OCI is easier via ocilib
https://vrogier.github.io/ocilib/



-- 
Björn

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Alain De Vos]

On Sunday, November 3, 2019 at 7:28:26 PM UTC+1, björn lundin wrote:
> Den 2019-10-31 kl. 18:17, skrev Alain De Vos:
> > In our modern time there are also modern databases.
> > But for connecting one needs a connector.
> > I wander to which databases I can connect with ada.
> > 
> 
> https://jrmarino.github.io/AdaBase/introduction.html
> (mysql,postgresql,sqlite)
> 
All connectors seem to be oriented towards relation databases ?
> others like ms sql-server -> ODBC
> 
> Oracle -> ODBC or native OCI.
> OCI is easier via ocilib
> https://vrogier.github.io/ocilib/
> 
> 
> 
> -- 
> Björn

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Alain De Vos]

On Thursday, October 31, 2019 at 6:18:01 PM UTC+1, Alain De Vos wrote:
> In our modern time there are also modern databases.
> But for connecting one needs a connector.
> I wander to which databases I can connect with ada.

It's nice to have connectors to relation databases.
But currently people are also developing query languages providing security or functionality on top of the sql-"text"-language.

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Björn Lundin]

Den 2019-11-03 kl. 19:41, skrev Alain De Vos:
> On Sunday, November 3, 2019 at 7:28:26 PM UTC+1, björn lundin wrote:
>> Den 2019-10-31 kl. 18:17, skrev Alain De Vos:

>>> In our modern time there are also modern databases.
> All connectors seem to be oriented towards relation databases ?
>> others like ms sql-server -> ODBC

Sorry I did not see the buzzwords in the subject.


-- 
Björn

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Marius Amado-Alves]

On Friday, 1 November 2019 at 13:51:27 UTC, Shark8 wrote:

> And there's an all-Ada graph-database called MNESON that I'm poking at to try to use Ada.Containers rather than the containers it's using. (Shark8)

Did you manage to do that?

Today I put Mneson on GitHub, including an adaptation of the 2005 code to build on present GNAT, but still with the non standard container lib.

Re: tokyocabinet,redis,mongodb,couchdb,influxdb,timescaledb connectors.

[Marius Amado-Alves]

> Today I put Mneson on GitHub...

https://github.com/marius-linguist/Mneson