View Web SQL data
Stay organized with collections
Save and categorize content based on your preferences.
This guide shows you how to use Chrome DevTools to inspect Web SQL data.
View Web SQL Data
Click the Sources tab to open the Application panel. Expand the Web SQL section to view databases and tables. In Figure 1 below
html5meetup is a database and rooms is a table.
Figure 1. The Web SQL pane.
Click a table to view that table's data.
Figure 2. Viewing the data of the rooms Web SQL table.
Edit Web SQL data
You can't edit Web SQL data when viewing a Web SQL table, such as in Figure 2 above. But you can
run statements from the Web SQL Console that edit or delete tables. See Run Web SQL queries.
Run Web SQL queries
- Click a database to open a console for that database.
Type a Web SQL statement, then press Enter to run it.
Figure 3. Using the Web SQL Console to delete a row from the rooms table.
Refresh a Web SQL table
DevTools does not update tables in real-time. To update the data in a table:
- View a Web SQL table's data.
- Click Refresh .
Filter out columns in a Web SQL table
- View a Web SQL table's data.
Use the Visible columns text box to specify what columns you want to show. Provide the
column names as a CSV list.
Figure 4. Using the Visible Columns text box to only show the room_name
and
last_updated
columns.
Delete all Web SQL data
- Open the Clear Storage pane.
Make sure that the Web SQL checkbox is enabled.
Figure 5. The Web SQL checkbox.
Click Clear site data.
Figure 6. The Clear Site Data button.
Except as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2019-03-25 UTC.
[{
"type": "thumb-down",
"id": "missingTheInformationINeed",
"label":"Missing the information I need"
},{
"type": "thumb-down",
"id": "tooComplicatedTooManySteps",
"label":"Too complicated / too many steps"
},{
"type": "thumb-down",
"id": "outOfDate",
"label":"Out of date"
},{
"type": "thumb-down",
"id": "samplesCodeIssue",
"label":"Samples / code issue"
},{
"type": "thumb-down",
"id": "otherDown",
"label":"Other"
}]
[{
"type": "thumb-up",
"id": "easyToUnderstand",
"label":"Easy to understand"
},{
"type": "thumb-up",
"id": "solvedMyProblem",
"label":"Solved my problem"
},{
"type": "thumb-up",
"id": "otherUp",
"label":"Other"
}]
{"lastModified": "Last updated 2019-03-25 UTC."}
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2019-03-25 UTC."],[],[]]