GitHub - dotCore-offsqlite-exporter An...

[charred charm]

why SQE.Config.Table? https://github.com/dotCore-off/sqlite-exporter/blob/0bcaea054ec8633b4a536bd82d7f2e00edbd9cad/sqi_exporter.lua#L75
you can export name of all tables via:

SELECT `name` FROM `sqlite_schema` WHERE `type` = "table" AND name NOT LIKE "sqlite_%";

also it would also be cool if you made the transfer of mysql credentials through a menu or console command - editing a config that is not even placed in a separate file is difficult for ordinary server owners

you could also make automatic types conversion, the only really necessary userinput is credentials.

[jade smelt]

I kinda want it to target only one table at a time to prevent massive export from SQLite and eventual overrides on remote database (eg: someone wanna export data from player_wallet, and script also exports player_infos while it already has data on remote)

Also, really cool idea, I'll probably make it into two console / chat commands

One to connect to remote database, one to export a table

My only concern would be about fetching column types, unsure if GMod supports table_info() or such function, or even have a schema table to retrieve info about existing tables

[jade smelt]

Update: it supports PRAGMA table_info so Imma probably go for it to fetch column order, name & type, rewriting it later today :)

[charred charm]

I dont think thats a problem. in most cases, you just want to move data from sqlite to an empty remote db

also you can add feature to make a dump, instead of direct interaction with the remote db - you could just do a dump and save it to a file or copy it to the clipboard.

I drew a schema, if I were developing this tool, I would make it something like this:

[jade smelt]

Gotcha, tysm for the schema, I'll do a rewrite of the entire script to make it similar to what you sent :)

[jade smelt]

Also for this, might just do some export_all thingy, or a table picker would be even better