search

Alecaddd / sequeler

SQL Client built in Vala
GNU General Public License v3.0
801 stars 66 forks source link

Add Support for MonetDB #347

Open eyalroz opened 3 years ago

eyalroz commented 3 years ago

MonetDB is a FOSS, analytics-oriented, columnar DBMS - almost the single one that's full-fledged rather than some research prototype, unfortunately. (There's MySQL Column Store but it's super slow).

It would be nice if Sequeler could support it. MonetDB uses a line protocol different than PostgreSQL and MySQL, called mapi. It described here:

https://www.monetdb.org/Documentation/SQLreference/Programming/MAPI

on the one hand, it's not very high-level, so you have to do some nitty-gritty work; on the other hand, it's pretty straightforward, so using it doesn't require some big framework or complex machinery.

Alecaddd commented 3 years ago

I think this is more a request for the LibGDA maintainers since Sequeler leverages that library for any DB interaction. I'll keep this open and see if there's any current compatibility. Thanks for the request

eyalroz commented 3 years ago

Thanks, Alessandro. I've just filed:

https://gitlab.gnome.org/GNOME/libgda/-/issues/232