r/sqlite • u/Ornery_Dealer5897 • 15d ago
how do i convert a sqlite file into something readable
i have a whatsapp sqlite file but what do i do with it i cant convert it, can view it in a mess
i just want to convert it into something readable.
2
u/Background-Front-925 15d ago edited 14d ago
whatsapp sqlite is encrypted, you can nothing about it outside whatsapp edit: It seems the sqlite db can be opened, learnt today
3
u/Ornery_Dealer5897 14d ago
appears not, i extracted sqlite from whatsapp domain opened it in db viewer and rows are all intact with visible data
1
u/lgastako 15d ago
If you're comfortable with command line tools I'd recommend https://www.visidata.org/ and if not I'd recommend https://datasette.io/.
1
u/GrogRedLub4242 15d ago
the sqlite tool can read it. it can be fed SQL select queries. you can tell it to dump the schema or schema/rows out to a SQL structured text file, which you can read in any plain text viewer or editor app
1
u/Temporary_Practice_2 15d ago
Use a sqlite browser or something like that.
Or download datagrip
1
u/Ornery_Dealer5897 14d ago
i dont want to mess around with sqlite browser and such i just want to input the sqlite database into an app that will convert it into a readable output such as imazing way of viewing a readable convo. Most tools only work with android msgstore.db, renaming extension does not work. Cannot find tools to convert to .db. prob why android has so much more to it cos most tools do what i want but only if its an android database,
1
u/Temporary_Practice_2 14d ago
Nah I don’t think you can convert a database to an app. What you actually need is to read the data…but it’s not the same experience as using the app that was built with the same data
1
1
u/fabiano-salles 13d ago
If you want something quick. Just go to https://fasttools.dev/en/sql-playground
You can open your database in the editor and export it to Excel. All in the browser. No need to install anything.
-5
u/Ornery_Dealer5897 15d ago
is there anyway i can convert this to .db i can find software that can show it more like whatsapp gui
-3
10
u/Massive_Show2963 15d ago
You can use a free UI app download that will open SQLite databases and show its contents.
https://letos.org/ (was SQLiteStudio).
See this tutorial I created using SQLite3 command line utility and SQLiteStudio:
Introduction To SQLite And SQLiteStudio
Or you could export the SQLite database as a CSV file using SQLite3 command line.
Tutorial below explains how to export:
Exporting Data With SQLite Using SQLite3 CLI