I would like to find an sqlite reader for Facebook's history file, places.sqlite, and similar files.
The only one I found only runs in Windows.
I run Windows in Parallels ... but trying to install the program caused
some major problems which I haven't yet resolved.
So I would very much like to find an OS X version.
I supposed I could just use some standard SQL program ... but then I
would probably have to use SQL myself to extract the details and get
them in a from I would like.
The Windows-based reader I found is specifically tailored to the
Facebook history file and has various built-in ways to interpret the
data, save it to other formats, etc.
So ... does anyone know of an OS X version?
Thanks.
On 2021-07-09, Dudley Brooks <dbrooks@runforyourlife.org> wrote:--
I would like to find an sqlite reader for Facebook's history file,
places.sqlite, and similar files.
The only one I found only runs in Windows.
I run Windows in Parallels ... but trying to install the program caused
some major problems which I haven't yet resolved.
So I would very much like to find an OS X version.
I supposed I could just use some standard SQL program ... but then I
would probably have to use SQL myself to extract the details and get
them in a from I would like.
The Windows-based reader I found is specifically tailored to the
Facebook history file and has various built-in ways to interpret the
data, save it to other formats, etc.
So ... does anyone know of an OS X version?
Thanks.
A quick web search for "macos sqlite reader" shows a few of them... Are
those not suitable for you
I would like to find an sqlite reader for Facebook's history file, places.sqlite, and similar files.
So I would very much like to find an OS X version.
I supposed I could just use some standard SQL program ... but then I
would probably have to use SQL myself to extract the details and get
them in a from I would like.
The Windows-based reader I found is specifically tailored to the
Facebook history file and has various built-in ways to interpret the
data, save it to other formats, etc.
So ... does anyone know of an OS X version?
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file,
places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily
use it to run SQL queries agains the databse and pretty much do whatever
you want.
/usr/bin/sqlite3
#v+
sqlite3 com.plexapp.plugins.library.db << ENDQUERY
SELECT
metadata_items.title,
metadata_items.added_at,
cast(ROUND(metadata_items.rating) as integer),
cast(ROUND(metadata_items.audience_rating) as integer),
metadata_items.year, guid,
metadata_items.originally_available_at, height,
video_codec, media_parts.size
FROM metadata_items
JOIN
media_parts,
media_items
WHERE
metadata_items.library_section_id=2
AND metadata_items.id=media_items.metadata_item_id
AND media_items.id=media_parts.media_item_id
AND media_parts.size>"200000000"
AND video_codec="hevc" AND height>"1200" ;
ENDQUERY
#v-
Works just fine and returns all the 4K HEVC files in the database.
On 2021-07-09, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file,
places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily
use it to run SQL queries agains the databse and pretty much do whatever
you want.
/usr/bin/sqlite3
#v+
sqlite3 com.plexapp.plugins.library.db << ENDQUERY
SELECT
metadata_items.title,
metadata_items.added_at,
cast(ROUND(metadata_items.rating) as integer),
cast(ROUND(metadata_items.audience_rating) as integer),
metadata_items.year, guid,
metadata_items.originally_available_at, height,
video_codec, media_parts.size
FROM metadata_items
JOIN
media_parts,
media_items
WHERE
metadata_items.library_section_id=2
AND metadata_items.id=media_items.metadata_item_id
AND media_items.id=media_parts.media_item_id
AND media_parts.size>"200000000"
AND video_codec="hevc" AND height>"1200" ;
ENDQUERY
#v-
Works just fine and returns all the 4K HEVC files in the database.
Yeah, I didn't bother mentioning that and figured he was looking for a generic GUI SQLite app that would automate it.
In message <iksjn3FpaepU1@mid.individual.net> Jolly Roger <jollyroger@pobox.com> wrote:
On 2021-07-09, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file, places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily use it to run SQL queries agains the databse and pretty much do whatever you want.
/usr/bin/sqlite3
#v+
sqlite3 com.plexapp.plugins.library.db << ENDQUERY
SELECT
metadata_items.title,
metadata_items.added_at,
cast(ROUND(metadata_items.rating) as integer),
cast(ROUND(metadata_items.audience_rating) as integer),
metadata_items.year, guid,
metadata_items.originally_available_at, height,
video_codec, media_parts.size
FROM metadata_items
JOIN
media_parts,
media_items
WHERE
metadata_items.library_section_id=2
AND metadata_items.id=media_items.metadata_item_id
AND media_items.id=media_parts.media_item_id
AND media_parts.size>"200000000"
AND video_codec="hevc" AND height>"1200" ;
ENDQUERY
#v-
Works just fine and returns all the 4K HEVC files in the database.
Yeah, I didn't bother mentioning that and figured he was looking for a generic GUI SQLite app that would automate it.
Are there general purpose apps that just magically parse a database? Seems to me they would need to be customized for the specific database to be at all useful.
Something that understood the plex database and let you really muck around in it without writing queries might be kind of cool, but I am not going to write it (especially since they keep changing the database format).
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file, places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily use it to run SQL queries agains the databse and pretty much do whatever you want.
/usr/bin/sqlite3
#v+
sqlite3 com.plexapp.plugins.library.db << ENDQUERY
SELECT
metadata_items.title,
metadata_items.added_at,
cast(ROUND(metadata_items.rating) as integer),
cast(ROUND(metadata_items.audience_rating) as integer),
metadata_items.year, guid,
metadata_items.originally_available_at, height,
video_codec, media_parts.size
FROM metadata_items
JOIN
media_parts,
media_items
WHERE
metadata_items.library_section_id=2
AND metadata_items.id=media_items.metadata_item_id
AND media_items.id=media_parts.media_item_id
AND media_parts.size>"200000000"
AND video_codec="hevc" AND height>"1200" ;
ENDQUERY
#v-
Works just fine and returns all the 4K HEVC files in the database.
So I would very much like to find an OS X version.
I supposed I could just use some standard SQL program ... but then I would probably have to use SQL myself to extract the details and get them in a from I would like.
that is how databases normally work, yes. You could also simply dump the entire database to a text file and find whatever info you are looking for.
The Windows-based reader I found is specifically tailored to the Facebook history file and has various built-in ways to interpret the data, save it to other formats, etc.
Yes, a tool to interact with a database needs to know how the database is formatted and setup, otherwise you need to do the SQL queries on your own.
So ... does anyone know of an OS X version?
#NeverFacebook
However, SQL is pretty straightforward.
The hardest part will be figuring out
what bullshit Facebook has done to obfuscate the way the link the data.
On 2021-07-09, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file, places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily use it to run SQL queries agains the databse and pretty much do whatever you want.
/usr/bin/sqlite3
#v+
sqlite3 com.plexapp.plugins.library.db << ENDQUERY
SELECT
metadata_items.title,
metadata_items.added_at,
cast(ROUND(metadata_items.rating) as integer),
cast(ROUND(metadata_items.audience_rating) as integer),
metadata_items.year, guid,
metadata_items.originally_available_at, height,
video_codec, media_parts.size
FROM metadata_items
JOIN
media_parts,
media_items
WHERE
metadata_items.library_section_id=2
AND metadata_items.id=media_items.metadata_item_id
AND media_items.id=media_parts.media_item_id
AND media_parts.size>"200000000"
AND video_codec="hevc" AND height>"1200" ;
ENDQUERY
#v-
Works just fine and returns all the 4K HEVC files in the database.
Yeah, I didn't bother mentioning that and figured he was looking for a generic GUI SQLite app that would automate it.
Are there general purpose apps that just magically parse a database?
Seems to me they would need to be customized for the specific database
to be at all useful.
In message <iksjn3FpaepU1@mid.individual.net> Jolly Roger <jollyroger@pobox.com> wrote:
On 2021-07-09, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file,
places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily >>> use it to run SQL queries agains the databse and pretty much do whatever >>> you want.
/usr/bin/sqlite3
[snip]
Works just fine and returns all the 4K HEVC files in the database.
Yeah, I didn't bother mentioning that and figured he was looking for a
generic GUI SQLite app that would automate it.
Are there general purpose apps that just magically parse a database?
Seems to me they would need to be customized for the specific database
to be at all useful.
Something that understood the plex database and let you really muck
around in it without writing queries might be kind of cool, but I am not going to write it (especially since they keep changing the database
format).
On 2021-07-10, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <iksjn3FpaepU1@mid.individual.net> Jolly Roger <jollyroger@pobox.com> wrote:
On 2021-07-09, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file,
places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily >>>> use it to run SQL queries agains the databse and pretty much do whatever >>>> you want.
/usr/bin/sqlite3
[snip]
Works just fine and returns all the 4K HEVC files in the database.
Yeah, I didn't bother mentioning that and figured he was looking for a
generic GUI SQLite app that would automate it.
Are there general purpose apps that just magically parse a database?
Sure, there are various general purpose database browser apps, for both
MySQL as well as SQLite. I use MySQL Workbench, DB Browser for SQLite,
and others regularly for that purpose.
Seems to me they would need to be customized for the specific database
to be at all useful.
Not really. Most of them let you execute SQL commands interactively and
do other DB operations in an automated fashion, often without needing to
run any SQL commands directly.
Something that understood the plex database and let you really muck
around in it without writing queries might be kind of cool, but I am not
going to write it (especially since they keep changing the database
format).
I haven't ever bothered looking at the Plex database before, but I just opened it in DB Browser without issue:
<https://imgur.com/a/qS5vVW4>
In message <ikuq4tF7d33U1@mid.individual.net> Jolly Roger <jollyroger@pobox.com> wrote:
On 2021-07-10, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <iksjn3FpaepU1@mid.individual.net> Jolly Roger <jollyroger@pobox.com> wrote:
On 2021-07-09, Lewis <g.kreme@kreme.dont-email.me> wrote:
In message <scacoe$ts1$1@dont-email.me> Dudley Brooks <dbrooks@runforyourlife.org> wrote:
I would like to find an sqlite reader for Facebook's history file, >>>>>> places.sqlite, and similar files.
I am not sure what you mean, sqlite3 is part of macOS and you can easily >>>>> use it to run SQL queries agains the databse and pretty much do whatever >>>>> you want.
/usr/bin/sqlite3
[snip]
Works just fine and returns all the 4K HEVC files in the database.
Yeah, I didn't bother mentioning that and figured he was looking
for a generic GUI SQLite app that would automate it.
Are there general purpose apps that just magically parse a database?
Sure, there are various general purpose database browser apps, for
both MySQL as well as SQLite. I use MySQL Workbench, DB Browser for
SQLite, and others regularly for that purpose.
Seems to me they would need to be customized for the specific
database to be at all useful.
Not really. Most of them let you execute SQL commands interactively
and do other DB operations in an automated fashion, often without
needing to run any SQL commands directly.
Something that understood the plex database and let you really muck
around in it without writing queries might be kind of cool, but I am
not going to write it (especially since they keep changing the
database format).
I haven't ever bothered looking at the Plex database before, but I
just opened it in DB Browser without issue:
<https://imgur.com/a/qS5vVW4>
that's not really any different than opening the datbase from the
command line, is it?
It doesn't look like it is relly showing you the data relationships.
If you open a specific title is it pulling in all the info from all
the tables to show every bit of information there is associated with
that title, or is it just the equivalent of dumping that record our of
one table and you have to figure out the connections yourself?
I would like to find an sqlite reader for Facebook's history file, places.sqlite, and similar files.
So ... does anyone know of an OS X version?
Thanks.
| Sysop: | Keyop |
|---|---|
| Location: | Huddersfield, West Yorkshire, UK |
| Users: | 379 |
| Nodes: | 16 (0 / 16) |
| Uptime: | 85:04:12 |
| Calls: | 8,091 |
| Files: | 13,069 |
| Messages: | 5,849,016 |