Skip to main content

SQLite Database: Notes

SQLite logo: https://upload.wikimedia.org/wikipedia/commons/thumb/3/38/SQLite370.svg/800px-SQLite370.svg.png

SQLite is free for everyone to use for any purpose.

SQLiteStudio is an open source SQLite database manager, released under GPLv3 license.

DB Browser for SQLite is a high quality, visual, open source tool to create, design, and edit database files compatible with SQLite.

sqlite3 --version : check version

.open path-to-db-file : open database file
.tables : list all tables in database
.schema table_name : describe table schema
.help : get help
.quit : quit sqlite
Labels:

Popular posts from this blog

Python: Notes

Read more

VMware Workstation: vmrun.exe

Using vmrun.exe to manage VMs on VMware Workstation
Read more

[GoogleAdsense] Notes from the field

Google AdSense: Notes from the field Cannot open ads in new tab/window Opening the ads in a new window Generally, it is our policy to not allow Google ads to open in a new window. However, in a few markets, including China, we've found that opening ads in a new window better aligns with expected internet behavior and provides a more consistent, intuitive user experience. Keeping in mind the importance of the user experience, we've enabled Google ads to open in new windows in locations where this is expected browsing behavior. This functionality is determined by the IP of the user, and is not an option you can select your AdSense account. We also ask that you don't modify the AdSense  ad code  or alter the result of clicking on an ad on your website, as such behavior violates our program policies.
Read more