Kosta Tarasov
Kosta Tarasov
Can I work on this?
With the first PR we were able to tick some of the boxes: * [x] Create several schema initialization .sql files, e.g. in `mbtiles/sql/` dir, add `init-flat.sql`, `init-flat-with-hash.sql`, etc. *...
After a bit of research it looks like `.read filename.sql` and `.readfile('image.png')` only works through `sqlite3` CLI, not the SQLite database engine we use via `sqlx`. So `sqlx` does not...
Sorry for the delay, how do you think we can use include_bytes! for this?
I see, we could do something like this (example for `world_cities.mbtiles`) 1. Initialize `.mbtile` tables with a `world_cities.sql` file (without the tiles data) 2. Do a loop through the corresponding...
I see. I was thinking about fully recreating the `mbtiles`, but they can have a lot of tiles (213tiles in `world_cities.sql`). Inserting every tile would be very tedious without some...
@mbelt Hey, do you need assistance with this?
@nyurik I tested including `.read` in .sql files and it worked. I created these test .sql files: `init.sql` ```sql CREATE TABLE meow ( text TEXT ); ``` `read.sql` ```sql .read...
Unfortunately, there isn't one. Will have to do that manually (a small script should do the work)
Should we create a new just recipe for creating .mbtiles from .sql files? We can integrate it in `just test`: ```diff -test: start (test-cargo "--all-targets") test-doc test-int +test: start prepare-fixtures...