You cannot download an "indexedDB database", as you refer to it. There is no such thing. How data is stored in indexedDb, in terms of the actual files and data format in each file, is not a part of the indexedDb API. It is not intended to be accessed in this manner. What you can do, is download data using a transferable format. A very well supported and common format to use in this case is JSON. JSON is a great format for downloading data. Consider writing a program that creates the JSON response on the server.
The browser extension can then download the JSON file s and then create objects in the indexedDb database in the browser in the context associated with the browser extension. In other words, export the data from the database on the server to JSON, transfer the json file or files or response bodies over HTTP, and then import the json into indexedDb. This is a very routine program design, regardless of the size of the data. When using an extension, such as Chrome extension, you can specify that you want unlimited data size, and you will get something that is "almost" unlimited, up to some percentage of your computer's storage capacity hard drive size.
Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Can a browser extension download a ready-to-use IndexedDB database? Ask Question. Asked 2 years ago. Active 1 year, 11 months ago.
Viewed times. Improve this question. Jomo Jomo 79 8 8 bronze badges. Is it going to use all one million entries "very frequently", or could you simply keep a cache for the most frequently used data? You could even make the cache entries never expire, so you effectively build the local database as you go, in exchange for slower initial requests. The ability to rebuild, refresh or restructure the data is useful generally, even if you're sure now that the data for existing entries won't change.
You could think of it as a spellchecker that checks all web pages for spelling errors or a filter program that checks all links on web sites and filters out the ones not suitable for children. So it could use a cache, but still would have to make hundreds of db requests for every page request.
If you're going to be making an extension that filters a very large amount of URLs, you can use a Bloom filter to improve both storage and performance considerably. For example, when renaming a column you might want to edit its data type or default value too. Before each of these modifications would be carried out immediately which, for large tables, makes editing them very slow and tiresome.
With this release DB4S keeps track of all your modifications, only applying them in one single process when clicking the OK button. This should make editing the schema of large tables a lot faster. We have also added a new constraint editor. This allows you to add and edit constraints for multiple columns but it is also useful for setting constraint names or just getting an overview of all constraints in the table.
We have added a new feature for configuring conditional formats in the Browse Data tab. With this, you can set colours, font, font size, text alignment, and more depending on the values of the cell. It works very similarly to what you might know from your spreadsheet application.
Conditional formats are set per column and multiple formats can be configured for each column. Conditional formats can select for anything that can be filtered for, e. Your configured conditional formats are saved to your project files as well. Additionally there is a new format toolbar which allows you to set formats arbitrarily without giving any condition. This allows you to format the table contents just like a table in your favourite spreadsheet application, e.
SQL queries are now running in a separate thread. This means the UI can respond while the query is running. For long-running queries, this makes a huge difference because it allows you to cancel the query anytime. SQLite does not support accessing the database from multiple threads simultaneously for all database configurations.
Because we want to make sure that it is impossible to corrupt a database file, DB4S does not allow two queries or one query and another long-running process to run simultaneously. In the status bar, you are now notified of any long-running processes and you can cancel them too. But no worries: Whenever you try to start a second query, a message box will inform you and let you decide whether to cancel or wait for the other process to finish.
It is now possible to sort by multiple columns in the Browse Data tab. You can configure any number of sort keys. Their order will appear in the column headers. Simply clicking a column header resets any old sort orders and sorts by just the clicked column.
To add another sort key hold the Ctrl key while clicking the column header. Holding the Ctrl key and clicking a column header which is already in the list of to columns for sorting changes the sort order of that column. All the columns used for sorting are stored in your project files.
The parser is not perfect and when failing to parse a certain table or index schema, you will not be able to use all features of DB4S on that table or index. Especially editing the schema but also to some extent modifying the contents of the table will not be possible. So even though it is not directly visible, the parser is a very important part of the application.
This release comes with a new parser. This allows us to fix a lot of problems, for example with complex CHECK constraints, which are now working as expected. The new parser is not only more robust, but it also extracts more information out of the SQL statements which makes editing these tables a smoother experience. Finally, the new parser can handle Unicode characters in table and column names just like SQLite does. So if your table schema contains these characters the table will now display correctly.
We have added a find toolbar and a find and replace dialog to the Execute SQL editors. This means you can quickly jump to your search terms in the Execute SQL editor using the toolbar. But you can also open the more powerful dialog for more search options or replacing text. There are new toolbar icons at the top with new keyboard shortcuts. We have also added the find and replace dialog to all other editors. This includes the Edit Cell and the SQL log docks because these might show a lot of text which is hard to navigate without a search option.
Additionally, we have added a new find and a new find and replace toolbar to the Browse Data tab. This allows you to look for values or patterns in the currently browsed table without applying a filter.
This is especially useful when you have already specified a filter and do not want to change that.
0コメント