This SQLite Viewer does not save or upload the file you select. It only works locally without going through the server. (HTML5 technology) Supports Chrome, IE10+, Firefox, Safari. Supported formats: sqlite, db, sqlite3, localstorage. 2021, SQLite Viewer with Google Drive. This SQLite Viewer does not save or upload the file you select. It only works locally without going through the server. (HTML5 technology) Supports Chrome, IE10+, Firefox, Safari. Supported formats: sqlite, db, sqlite3, localstorage. 2021, SQLite Viewer with Google Drive. Delete content-prefs.sqlite file. Firefox stores your data in various files in your profile folder. The file used for saving individual website settings might be corrupt. If you delete (or rename) that file, your zoom level settings will be reset but it could decrease CPU usage. Users of SQLite 3.19.0 should upgrade, but users of all prior versions of SQLite are safe. 2017-05-22 - Release 3.19.0 SQLite version 3.19.0 is a regularly scheduled maintenance release.

1. Sqlite File Reader
2. Sqlite Firefox Windows
3. Sqlite Firefox Plugin
4. Sqlite Firefox

Sqlite File Reader

The Web Storage API provides mechanisms by which browsers can store key/value pairs, in a much more intuitive fashion than using cookies.

Web Storage concepts and usage

The two mechanisms within Web Storage are as follows:

• sessionStorage maintains a separate storage area for each given origin that's available for the duration of the page session (as long as the browser is open, including page reloads and restores)
  • Stores data only for a session, meaning that the data is stored until the browser (or tab) is closed.
  • Data is never transferred to the server.
  • Storage limit is larger than a cookie (at most 5MB).
• localStorage does the same thing, but persists even when the browser is closed and reopened.
  • Stores data with no expiration date, and gets cleared only through JavaScript, or clearing the Browser cache / Locally Stored Data.
  • Storage limit is the maximum amongst the three.

These mechanisms are available via the Window.sessionStorage and Window.localStorage properties (to be more precise, in supporting browsers the Window object implements the WindowLocalStorage and WindowSessionStorage objects, which the localStorage and sessionStorage properties hang off) — invoking one of these will create an instance of the Storage object, through which data items can be set, retrieved and removed. A different Storage object is used for the sessionStorage and localStorage for each origin — they function and are controlled separately.

Note: From Firefox 45 onwards, when the browser crashes/restarts, the amount of data saved per origin is limited to 10MB. This has been done to avoid memory issues caused by excessive usage of web storage.

Note: Access to Web Storage from third-party IFrames is denied if the user has disabled third-party cookies (Firefox implements this behavior from version 43 onwards.)

Note: Web Storage is not the same as mozStorage (Mozilla's XPCOM interfaces to SQLite) or the Session store API (an XPCOM storage utility for use by extensions).

Web Storage interfaces

Examples

To illustrate some typical web storage usage, we have created a simple example, imaginatively called Web Storage Demo. The landing page provides controls that can be used to customize the color, font and decorative image. When you choose different options, the page is instantly updated; in addition your choices are stored in localStorage, so that when you leave the page then load it again later on your choices are remembered.

In addition, we have provided an event output page — if you load this page in another tab, then make changes to your choices in the landing page, you'll see the updated storage information outputted as the StorageEvent is fired.

Specifications

Browser compatibility

Window.localStorage

BCD tables only load in the browser

Window.sessionStorage

BCD tables only load in the browser

Private Browsing / Incognito modes

Most modern browsers support a privacy option called 'Incognito', 'Private Browsing' or something similar that doesn't store data like history and cookies. This is fundamentally incompatible with Web Storage for obvious reasons. As such, browser vendors are experimenting with different scenarios for how to deal with this incompatibility.

Most browsers have opted for a strategy where storage APIs are still available and seemingly fully functional, with the one big difference that all stored data is wiped after the browser is closed. For these browsers there are still different interpretations of what should be done with existing stored data (from a regular browsing session). Should it be available to read when in Private mode? Then there are some browsers, most notably Safari, that have opted for a solution where storage is available, but is empty and has a quota of 0 bytes assigned, effectively making it impossible to write data to it.

Developers should be aware of these different implementations and take them into account when developing websites depending on Web Storage APIs. For more information please have a look at this WHATWG blog post that specifically deals with this topic.

Sqlite Firefox Windows

See also

Locating Your Zotero Data

The easiest and most reliable way to find your Zotero data is by clicking the “Show Data Directory” button in the Advanced tab of your Zotero Preferences window. This will reveal the folder on your computer that contains your Zotero database and attachment files.

Default Locations

Zotero 5

Unless you have selected a custom data directory in the Advanced pane of the Zotero preferences, your Zotero data is stored within the following OS-dependent directories:

Zotero 4 for Firefox (2017 and earlier)

Zotero 4 Standalone (2017 and earlier)

The “Show Data Directory” button will always reveal the data directory currently in use and is the recommended method for finding your data directory. If you're unable to access the Zotero preferences, a search for the file name 'zotero.sqlite' can also help you locate the Zotero data directory.

Data Directory Contents

The most important file in the data directory is the zotero.sqlite file, which contains the majority of your data: item metadata, notes, tags, etc. When Zotero starts up, it reads the zotero.sqlite file in the active data directory.

The directory also contains a 'storage' subdirectory, containing all of your file attachments, such as PDFs, web snapshots, audio files, or any other files you have imported. (Files that are linked are not copied into this subdirectory.)

Your data directory will likely contain several other files. These can include zotero.sqlite.bak (an automatic backup of zotero.sqlite, which is updated when you quit Zotero and the existing zotero.sqlite.bak file hasn't been updated in the last 12 hours) and zotero.sqlite.[number].bak files (automatic backups of zotero.sqlite that are created during certain Zotero updates).

Warning: Before you copy, delete, or move any of these files, be sure that Zotero is closed. Failure to do so before moving these files can damage your data.

Backing Up Your Zotero Data

We strongly recommend that you regularly back up your Zotero database. Syncing is not a good substitute for backing up: the Zotero servers only store the most recent version of your libraries, and it takes just a single (possibly automatic) sync to change the server copy.

Rather than backing up just your Zotero database, we recommend using a backup utility that automatically backs up your entire hard drive to an external device on a regular basis. Most modern operating systems offer such functionality (e.g., Time Machine on Macs).

If you want to back up your Zotero data specifically, locate your Zotero data, close Zotero, and copy your data directory (the entire directory, including zotero.sqlite and storage and the other subdirectories) to a backup location, preferably on another storage device. As with all important data, it is a good idea to back up your Zotero data frequently.

Warning: Zotero lets you export a Zotero library as a Zotero RDF file. However, exporting and importing your library via RDF won't result in an exact copy of your library, and it isn't recommended as a backup strategy.

Restoring Your Zotero Data From a Backup

Between manual backups, automatic backups, and synced data, it's often possible to restore a lost Zotero library or restore data that was accidentally deleted.

Before following these steps, be sure that Zotero is looking in the right place for your data.

Restoring Your Zotero Data Using Zotero Syncing

If you were using Zotero syncing and have an empty local library, you can likely restore your data simply by syncing with your online library. After verifying that your library is correct on zotero.org, simply reenter your username and password in the Sync pane of the Zotero preferences and click the Sync button in the toolbar. (Zotero only syncs explicit deletions, so just syncing an empty library won't overwrite the server data unless you deleted items manually.)

If you have a local Zotero library that you want to overwrite, close Zotero and delete the old Zotero data directory before syncing. Syncing your database with a different Zotero account will also prompt you to remove the existing local database.

Restoring Your Zotero Data From a Backup

If you were not using Zotero syncing (or were but don't want to perform a full sync) and have a backup of your Zotero data directory, you can restore your library by replacing your active data directory with your backed-up data directory.

Open the Advanced pane of the Zotero preferences and make a note of the specified path under Data Directory Location. (By default, this will be “Zotero” within your home directory.) Click “Show Data Directory”, which should reveal your active data directory containing zotero.sqlite and possibly a 'storage' subdirectory. Close Zotero, move one level up in the filesystem (Cmd-up-arrow on macOS, Alt-up-arrow on Windows), and rename the directory to “Zotero-Old”. Next, copy the data directory from your backup to the original location (e.g., “Zotero”).

When you reopen Zotero, you should see your restored Zotero data.

Once you've successfully restored your data, you can delete the “Zotero-Old” folder, but it's a good idea to keep it for a while until you're sure your data is correct.

Note that, if you were using Zotero syncing, any changes you made to your library since the backup and subsequently synced to your online library will be applied to your restored database as soon as you sync. If you don't want that to happen, see the following section.

Restoring Your Zotero Data From a Backup and Overwriting Synced Changes

If you or someone else made unwanted changes to your Zotero library and synced those changes to your online library, you may be able to restore data by using a local backup of your Zotero data directory.

1. Temporarily disable auto-sync in the Sync pane of the Zotero preferences.
2. Follow the steps in the preceding section to restore from a backup of your Zotero data directory.
3. Once you see your restored data, were you to sync again, the more recent data in the online library would replace the data you just restored, and you'll need to take steps to prevent that:
   • If you're trying to restore a small number of deleted items or notes, you can simply duplicate the items — by right-clicking and choosing “Duplicate Item(s)” — so that the new copies remain even after syncing.
   • If you're trying to restore deleted collections, you can create duplicate collections and drag items from the old collections to the new ones. When you sync, the old collections will be deleted but the new ones will remain.
   • If many items were affected or collections were deleted, you can use Replace Online Library to force Zotero to upload the local version of the library, overwriting previously synced changes.

If you're happy with the results, you can re-enable auto-sync and continue working.

Restoring From the Last Automatic Backup

If you make a critical mistake while using Zotero — for example, if you accidentally delete a large set of items — you may be able to revert to the last automatic backup. Note that automatic backups contain only data, not files.

1. First, make sure to keep Zotero running, as the automatic backup might be overwritten when you quit the application.
2. If you're using syncing, temporarily disable auto-sync in the Sync pane of the Zotero preferences.
3. Locate your Zotero data and make a copy of any zotero.sqlite.bak files. The timestamps of the files may help you determine which file would contain the data you're trying to restore.
4. Close Zotero. In your data directory, rename zotero.sqlite to zotero.sqlite.old, rename one of the .bak copies you made to zotero.sqlite, and restart Zotero. You should now see the backed-up version of your library.
5. If you were using syncing and the undesired changes were already synced, syncing now would cause the more recent data in the online library to replace the data you just restored, and you'll need to take steps to prevent that:
   • If you're trying to restore a small number of deleted items or notes, you can simply duplicate the items — by right-clicking and choosing “Duplicate Item(s)” — so that the new copies remain even after syncing.
   • If you're trying to restore deleted collections, you can create duplicate collections and drag items from the old collections to the new ones. When you sync, the old collections will be deleted but the new ones will remain.
   • If many items were affected or collections were deleted, you can use Replace Online Library to force Zotero to upload the local version of the library, overwriting previously synced changes.

If you're happy with the results, you can re-enable auto-sync and continue working. Keep zotero.sqlite.old until you're sure all your data is intact and in sync across all your computers.

Restoring From the Last Upgrade Backup

When you upgrade to a major new version of Zotero, Zotero will automatically update your database to work with the new version. If you would like to revert to a previous version of Zotero at a later point, you will have to manually replace your database with the automatic backup Zotero made during the upgrade. In most cases this will be the highest-numbered “zotero.sqlite.[num].bak” file in your Zotero data directory.

It's a good idea to make a backup of your entire Zotero data directory before making any changes.

If you have synced your data with the Zotero servers, reverting to a previous version is as simple as reinstalling the previous version, closing Zotero, replacing “zotero.sqlite” in your Zotero data directory with “zotero.sqlite.[highest-number].bak”, and restarting Zotero. (Note that if you try to open an upgraded database in an earlier version, Zotero will display an error. Just close Zotero and replace the .sqlite file.) Zotero will then sync from the online library any changes made since you last used the older database.

If you were not using syncing, you may wish to export to Zotero RDF any items added since the database upgrade and then reimport those into the earlier version. Sorting your library by Date Added may help you find such items.

Bear in mind that word processor documents used with later Zotero versions may not be usable with earlier versions, and Zotero developers and community members will provide only limited support for earlier versions (mostly to recommend upgrading to the current version).

Locating Missing Zotero Data

If you open Zotero to find your library blank or missing lots of data, don't panic. Data is never removed unless you delete it, so Zotero is most likely looking at a different database from the one you were using previously. You need to make sure that Zotero is looking in the right location for your Zotero files and that the right files are in that spot.

Sqlite Firefox Plugin

If you recently updated to Zotero 5 from Zotero 4 and are missing data, see Missing Data After Zotero 5 Upgrade. Zotero 5 was released in 2017, so this no longer applies to most people.

If you're using a different computer from the one where you created the missing data, and your data is also missing in your online library, your data simply hasn't synced from the computer where you created it. See Changes Not Syncing.

If you're using the same computer where you originally created the missing data, you'll need to locate your Zotero data on this computer. Use the “Show Data Directory” button in the Advanced pane of the Zotero preferences to reveal the current data directory. Take note of the names, sizes, and dates of the files beginning with “zotero.sqlite” in this folder, which are your Zotero database and automatic database backups. An empty Zotero database will be either approximately 1 MB (~1,000 KB) or 5 MB.

If you see only 1 MB or 5 MB zotero.sqlite files, look in the 'storage' folder (if one exists) for folders with dates corresponding with your previous usage of Zotero. If you see them, this is likely the Zotero data directory you were using previously, but something happened to the zotero.sqlite database outside of Zotero — for example, you might have accidentally deleted zotero.sqlite using system tools while trying to clear disk space. In this case, you may need to restore the file from a backup, either any larger zotero.sqlite.bak files you see in that folder or in a separate backup. (It's not possible to restore your data from the 'storage' files alone.) When Zotero starts up, it reads the zotero.sqlite file in the active data directory, so you can try other copies of zotero.sqlite by moving or renaming them to that location. Do not try to import an .sqlite file into Zotero via File → “Import…” — it won't work.

Sqlite Firefox

If this isn't the directory you were expecting to be using, or if you don't see a 'storage' directory, you'll need to locate your previous data directory on your computer and either select that data directory from the preferences or, with Zotero closed, rename the current directory (e.g., to “Zotero-Old”) and move your desired Zotero directory to the specified location. If you're not sure where your most recent Zotero data is located, look for versions of zotero.sqlite or zotero.sqlite.bak larger than 5 MB with appropriate modification times stored elsewhere on your computer and look at the dates of the folders within the 'storage' folder.

Unless you have a good reason to use a custom data directory location, we recommend using the default location in your home directory.

When specifying a custom data directory location, keep in mind that Zotero doesn't move or copy any data. You still need to copy your data into the specified location. Also, when pointing the data directory location to an existing folder, be sure to specify the parent folder containing zotero.sqlite and 'storage', not the 'storage' folder itself.

If you've gone through these steps and still can't find your data, post to the Zotero Forums with the following info:

• The names, sizes, and dates of all files beginning with “zotero.sqlite” in your current data directory
• Whether there's a 'storage' folder containing subfolders with dates corresponding to your previous usage of Zotero
• Whether your current data directory is in the default location (“Zotero” in your home folder)
• When you last used Zotero on this computer, and what happened on your computer since then