Skip to content

Instantly share code, notes, and snippets.

@jkoan

jkoan/sqlite-export.sql

Created April 11, 2020 16:03
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save jkoan/f3bf9d07aca8459808a9216b0b9a0c32 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save jkoan/f3bf9d07aca8459808a9216b0b9a0c32 to your computer and use it in GitHub Desktop.
Download ZIP
Idea of Navit Sqlite Export
Raw
sqlite-export.sql
ATTACH DATABASE "/export/export_XYZ.db" as 'export'; -- Must exists priore (DL-Server can handle this)
BEGIN TRANSACTION;
CREATE TABLE export.points AS SELECT * FROM points WHERE ; -- Select can be as complicated as wanted
-- More tables here once defined
END TRANSACTION;
VACUUM "export";
PRAGMA optimize;
DETACH 'export'; -- Download File Finished
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment