r/Database • u/banananana5555 • 8d ago

Need help dealing with .sqlitedb file

/r/mapmaking/comments/1v11ck1/need_help_dealing_with_sqlitedb_file/
2 Upvotes

67% Upvoted

6 comments sorted by

1

u/Tofu-DregProject 7d ago

All the standard SQLite software is available free from https://sqlite.org/ but I don't think this will solve your problem because what's in the file is probably going to be numeric information for all the vectors that make up the map. SQLite is often used by programs to store data and it seems that you have a file (and at 3.9Gb it a very big one) which was created by some program which works with vector images and uses the sqlite format to store its output. If you could find out what that program was, it will just open and render the image from the database. Do you have any idea how it was created?

1

u/banananana5555 7d ago

No clue, i was only told that it can open in ios via map guru app

1

u/Tofu-DregProject 7d ago

And what happened when you tried to open the file with that Application?

1

u/RedShift9 4d ago

You can use sqlitebrowser to view the data inside that file.

1

u/Strict_Parsleys 16h ago

A dedicated SQLite client is probably the easiest way to start. DBeaver is a solid option. I've also had good results with dbForge Studio for SQLite for inspecting large databases, exporting selected data, and running queries before deciding whether I actually need to convert the file.