First problem sounds like you have a problem with spaces in the filename.

The second issue sounds like, although there is a sign over the road that says "Browse Data", when you throw a baseball at that sign, no "Browse Data" occurs.

This should be taken up with the sign-maker in order to determine the proper way to hit the "Browse Data" sign in order to "Browse Data". Since no one here put up the sign it is unlikely that anyone here will be able to help you.

trying to use this software

The SQLite team made only one piece of software a non-programmer would use. It's very technical, and it's unlikely you used it. On a Mac you would have to be running Terminal.app to get at it.

I'm guessing you used SQLite Browser or something like that. Those programs are written by other people and the SQLite team can't support them. SQLite itself does not have error messages like 'unable to open database file'.

Can I ask why you're not using Safari to look at your Safari history ? That would seem the obvious way to do it. If I know why that isn't working I might be able to help.

Also, do you have the pages you need bookmarked, or just in your history ?

I'm really interested in how to open this file. I have huge Safari history. Last year, I followed classes in a foreign country, and had an e-class system with all my projects, classes supports... I cannot access to the e-class specific web pages from my login page (which I still have access to). But I figured accessing it through the web page by the History URL opens to the exact files, and even video recordings, exactly what I'm looking for. I'd like to filter my history with those criteria, and be able to recover all my classes, which were very interesting :)

Works find for me when I use the Command Line Shell provided by the sqlite3 team.

Quit Safari. Copy the History.db file somewhere else. (You can restart Safari now if you want.) Open the copy you made with the sqlite3:

simon@183 Desktop % sqlite3 History.db
SQLite version 3.36.0 2021-06-18 18:58:49
Enter ".help" for usage hints.
sqlite> .mode table
sqlite> SELECT * FROM history_items LIMIT 3;
+--------+---------------------------------------+------------------+-------------+--------------------+---------------------+-----------------------+---------------------------------------+-------------------+-------------+
|   id   |                  url                  | domain_expansion | visit_count | daily_visit_counts | weekly_visit_counts | autocomplete_triggers | should_recompute_derived_visit_counts | visit_count_score | status_code |
+--------+---------------------------------------+------------------+-------------+--------------------+---------------------+-----------------------+---------------------------------------+-------------------+-------------+
| 201295 | https://slashdot.org/                 |                  | 7197        | ?                  | a???                |                       | 1                                     | 5100              | 0           |
| 201315 | https://news.ycombinator.com/         | news.ycombinator | 4837        | ?                  |                     |                       | 1                                     | 5100              | 0           |
| 201321 | https://www.reddit.com/               | reddit           | 11152       | }                  | `	             |                       | 0                                     | 5920              | 0           |
+--------+---------------------------------------+------------------+-------------+--------------------+---------------------+-----------------------+---------------------------------------+-------------------+-------------+
sqlite> .quit

SQLite itself does not have error messages like 'unable to open database file'.

sqlite3.c:144789:    /* SQLITE_CANTOPEN    */ "unable to open database file",

That's not an error message. It's a comment to a line in a C program.

No, it's a comment in front of an error message, which you can retrieve via sqlite3_errmsg().

You're right. Thanks for the correction.