Feature request: Postgresql module

[timoc]

hi,

I use postgres for my database needs.
It would like to be able to use the virtualpg+sqlite3 and native postgresql for database backends and query writing

[pcmacdon]

Interesting. I've never used virtualpg myself, but I was able to build and load it in Jsi with:

var db = new Sqlite(null,{load:true});
db.query("SELECT load_extension('./mod_virtualpg.so')");

So no new feature is required.

https://www.sqlite.org/loadext.html

[timoc]

I could not find any documentation on this, but to be clear, the goal is:

One codebase containing one set of PostgresQL SQL queries, that can use postgres or SQLite3 as a backend.

including using postgres based schema creation scripts.

And then the ability to use jsish to work with either.

[pcmacdon]

Not sure I understand above: is this a question?

As mentioned, I have no previous experience using virtualpg, but was able to built it, and enable/load it in jsish no problem.

I didn't go further, but you should then be able to follow the tutorial:

https://www.gaia-gis.it/fossil/virtualpg/wiki?name=tutorial

This seems to imply the schema/table creation is PostgresQL-only, but I could be wrong about that.

That said, I think virtualpg is a very cool idea. And I think it would be even better if there was a virtualmysql/mariadb.

[timoc]

thanks will give it a try