René's URL Explorer Experiment


Title: Command Line Shell For SQLite

direct link

Domain: sqlite.org

Nonetext/html; charset=UTF-8

Links:

https://sqlite.org/index.html
Homehttps://sqlite.org/index.html
Menujavascript:void(0)
Abouthttps://sqlite.org/about.html
Documentationhttps://sqlite.org/docs.html
Downloadhttps://sqlite.org/download.html
Licensehttps://sqlite.org/copyright.html
Supporthttps://sqlite.org/support.html
Purchasehttps://sqlite.org/prosupport.html
Searchjavascript:void(0)
Abouthttps://sqlite.org/about.html
Documentationhttps://sqlite.org/docs.html
Downloadhttps://sqlite.org/download.html
Supporthttps://sqlite.org/support.html
Purchasehttps://sqlite.org/prosupport.html
1. Getting Startedhttps://sqlite.org/cli.html#getting_started
1.1. SQLite command-line program versus the SQLite libraryhttps://sqlite.org/cli.html#sqlite_command_line_program_versus_the_sqlite_library
1.2. GUI Alternatives To The CLIhttps://sqlite.org/cli.html#gui_alternatives_to_the_cli
1.3. Starting the CLIhttps://sqlite.org/cli.html#starting_the_cli
1.4. Double-click Startup On Windowshttps://sqlite.org/cli.html#double_click_startup_on_windows
2. Special commands to sqlite3 (dot-commands)https://sqlite.org/cli.html#special_commands_to_sqlite3_dot_commands_
3. Rules for "dot-commands", SQL and Morehttps://sqlite.org/cli.html#rules_for_dot_commands_sql_and_more
3.1. Line Structurehttps://sqlite.org/cli.html#line_structure
3.2. Dot-command argumentshttps://sqlite.org/cli.html#dot_command_arguments
3.3. Dot-command executionhttps://sqlite.org/cli.html#dot_command_execution
4. Changing Output Formatshttps://sqlite.org/cli.html#changing_output_formats
4.1. Control of line endingshttps://sqlite.org/cli.html#control_of_line_endings
4.2. Control characters in outputhttps://sqlite.org/cli.html#control_characters_in_output
5. Querying the database schemahttps://sqlite.org/cli.html#querying_the_database_schema
6. Opening Database Fileshttps://sqlite.org/cli.html#opening_database_files
7. Redirecting I/Ohttps://sqlite.org/cli.html#redirecting_i_o
7.1. Writing results to a filehttps://sqlite.org/cli.html#writing_results_to_a_file
7.2. Reading SQL from a filehttps://sqlite.org/cli.html#reading_sql_from_a_file
7.3. File I/O Functionshttps://sqlite.org/cli.html#file_i_o_functions
7.4. The edit() SQL functionhttps://sqlite.org/cli.html#the_edit_sql_function
7.5. Importing files as CSV or other formatshttps://sqlite.org/cli.html#importing_files_as_csv_or_other_formats
7.6. Export to CSVhttps://sqlite.org/cli.html#export_to_csv
7.6.1. Export to Excel https://sqlite.org/cli.html#_export_to_excel_
7.6.2. Export to TSV (tab separated values)https://sqlite.org/cli.html#_export_to_tsv_tab_separated_values_
8. Accessing ZIP Archives As Database Fileshttps://sqlite.org/cli.html#accessing_zip_archives_as_database_files
8.1. How ZIP archive access is implementedhttps://sqlite.org/cli.html#how_zip_archive_access_is_implemented
9. Converting An Entire Database To A Text Filehttps://sqlite.org/cli.html#converting_an_entire_database_to_a_text_file
10. Recover Data From a Corrupted Databasehttps://sqlite.org/cli.html#recover_data_from_a_corrupted_database
11. Loading Extensionshttps://sqlite.org/cli.html#loading_extensions
12. Cryptographic Hashes Of Database Contenthttps://sqlite.org/cli.html#cryptographic_hashes_of_database_content
13. Database Content Self-Testshttps://sqlite.org/cli.html#database_content_self_tests
14. SQLite Archive Supporthttps://sqlite.org/cli.html#sqlite_archive_support
14.1. SQLite Archive Create Command https://sqlite.org/cli.html#_sqlite_archive_create_command_
14.2. SQLite Archive Extract Command https://sqlite.org/cli.html#_sqlite_archive_extract_command_
14.3. SQLite Archive List Command https://sqlite.org/cli.html#_sqlite_archive_list_command_
14.4. SQLite Archive Insert And Update Commands https://sqlite.org/cli.html#_sqlite_archive_insert_and_update_commands_
14.5. SQLite Archive Remove Command https://sqlite.org/cli.html#_sqlite_archive_remove_command_
14.6. Operations On ZIP Archives https://sqlite.org/cli.html#_operations_on_zip_archives_
14.7. SQL Used To Implement SQLite Archive Operations https://sqlite.org/cli.html#_sql_used_to_implement_sqlite_archive_operations_
15. SQL Parametershttps://sqlite.org/cli.html#sql_parameters
16. Index Recommendations (SQLite Expert)https://sqlite.org/cli.html#index_recommendations_sqlite_expert_
17. Working With Multiple Database Connectionshttps://sqlite.org/cli.html#working_with_multiple_database_connections
18. Miscellaneous Extension Featureshttps://sqlite.org/cli.html#miscellaneous_extension_features
19. Other Dot Commandshttps://sqlite.org/cli.html#other_dot_commands
20. Using sqlite3 in a shell scripthttps://sqlite.org/cli.html#using_sqlite3_in_a_shell_script
21. Marking The End Of An SQL Statementhttps://sqlite.org/cli.html#marking_the_end_of_an_sql_statement
22. More Details On How To Start The CLIhttps://sqlite.org/cli.html#more_details_on_how_to_start_the_cli
22.1. Extra command-line argumentshttps://sqlite.org/cli.html#extra_command_line_arguments
22.2. Command-line Optionshttps://sqlite.org/cli.html#command_line_options
22.3. The --safe command-line optionhttps://sqlite.org/cli.html#the_safe_command_line_option
22.3.1. Bypassing --safe restrictions for specific commandshttps://sqlite.org/cli.html#bypassing_safe_restrictions_for_specific_commands
22.4. The --unsafe-testing command-line optionhttps://sqlite.org/cli.html#the_unsafe_testing_command_line_option
22.5. The --no-utf8 and --utf8 command-line optionshttps://sqlite.org/cli.html#the_no_utf8_and_utf8_command_line_options
23. Compiling the sqlite3 program from sourceshttps://sqlite.org/cli.html#compiling_the_sqlite3_program_from_sources
23.1. Do-It-Yourself Builds https://sqlite.org/cli.html#_do_it_yourself_builds_
ZIP archivehttps://sqlite.org/cli.html#zipdb
Visual DBhttps://visualdb.com/sqlite
https://visualdb.com/sqlite
ZIP archivehttps://sqlite.org/cli.html#zipdb
sqlite3_prepare()https://sqlite.org/c3ref/prepare.html
sqlite3_exec()https://sqlite.org/c3ref/exec.html
CSV outputhttps://sqlite.org/cli.html#csvout
ANSI escape codeshttps://en.wikipedia.org/wiki/ANSI_escape_code
sqlite_schemahttps://sqlite.org/schematab.html
attachedhttps://sqlite.org/lang_attach.html
attachedhttps://sqlite.org/lang_attach.html
sqlite3_txn_state()https://sqlite.org/c3ref/txn_state.html
sqlite3_open()https://sqlite.org/c3ref/open.html
sqlite3_deserialize()https://sqlite.org/c3ref/deserialize.html
appendvfs extensionhttps://sqlite.org/src/file/ext/misc/appendvfs.c
dot-commandshttps://sqlite.org/cli.html#dotcmd
application-defined SQL functionshttps://sqlite.org/appfunc.html
loadable extensionhttps://sqlite.org/loadext.html
ext/misc/fileio.chttps://sqlite.org/src/artifact?ci=trunk&filename=ext/misc/fileio.c
SQLite source code repositorieshttps://sqlite.org/download.html#srctree
file I/O functionshttps://sqlite.org/cli.html#fileio
Zipfile virtual tablehttps://sqlite.org/zipfile.html
in-memory databasehttps://sqlite.org/inmemorydb.html
Zipfile virtual tablehttps://sqlite.org/zipfile.html
Zipfile virtual tablehttps://sqlite.org/zipfile.html
CREATE VIRTUAL TABLEhttps://sqlite.org/lang_createvtab.html
application-defined SQL functionshttps://sqlite.org/appfunc.html
collating sequenceshttps://sqlite.org/datatype3.html#collation
virtual tableshttps://sqlite.org/vtab.html
VFSeshttps://sqlite.org/vfs.html
Run-Time Loadable Extensionshttps://sqlite.org/loadext.html
ext/mischttps://sqlite.org/src/tree?name=ext/misc&ci=trunk
SHA3https://en.wikipedia.org/wiki/SHA-3
VACUUMhttps://sqlite.org/lang_vacuum.html
sqlite_schemahttps://sqlite.org/schematab.html
LIKEhttps://sqlite.org/lang_expr.html#like
LIKEhttps://sqlite.org/lang_expr.html#like
extension function "sha3_query()"https://sqlite.org/src/file/ext/misc/shathree.c
PRAGMA integrity_checkhttps://sqlite.org/pragma.html#pragma_integrity_check
DELETEhttps://sqlite.org/lang_delete.html
SQLite Archive formathttps://sqlite.org/sqlar.html
apndvfs VFShttps://sqlite.org/src/file/ext/misc/appendvfs.c
glob(Y,X)https://sqlite.org/lang_corefunc.html#glob
zipfilehttps://sqlite.org/zipfile.html
loadable extensionshttps://sqlite.org/loadext.html
SQLite source treehttps://sqlite.org/src
ext/misc/ subfolderhttps://sqlite.org/src/file/ext/misc
fileio.chttps://sqlite.org/src/file/ext/misc/fileio.c
sqlar.chttps://sqlite.org/src/file/ext/misc/sqlar.c
zipfile.chttps://sqlite.org/zipfile.html
appendvfs.chttps://sqlite.org/src/file/ext/misc/appendvfs.c
VFShttps://sqlite.org/vfs.html
bound parametershttps://sqlite.org/lang_expr.html#varparam
sqlite3_bind_...()https://sqlite.org/c3ref/bind_blob.html
command-line shell source codehttps://sqlite.org/src/file/src/shell.c.in
EXPLAIN QUERY PLANhttps://sqlite.org/eqp.html
SQLite query plannerhttps://sqlite.org/optoverview.html
ANALYZEhttps://sqlite.org/lang_analyze.html
SQLite expert extensionhttps://sqlite.org/src/dir?ci=trunk&name=ext/expert
Automatically Load Statically Linked Extensionshttps://sqlite.org/c3ref/auto_extension.html
Persistent Loadable Extensionshttps://sqlite.org/loadext.html#persist
database connectionshttps://sqlite.org/c3ref/sqlite3.html
output modehttps://sqlite.org/cli.html#dotmode
dot-commandshttps://sqlite.org/cli.html#dotcmd
.openhttps://sqlite.org/cli.html#dotopen
UINT collating sequencehttps://sqlite.org/uintcseq.html
decimal extensionhttps://sqlite.org/floatingpoint.html#decext
generate_serieshttps://sqlite.org/series.html
base64()https://sqlite.org/base64.html
base85()https://sqlite.org/base85.html
REGEXPhttps://sqlite.org/lang_expr.html#regexp
previouslyhttps://sqlite.org/cli.html#startup
dot-commandhttps://sqlite.org/cli.html#dotcmd
.open commandhttps://sqlite.org/cli.html#dotopen
ATTACHhttps://sqlite.org/lang_attach.html
.archive commandhttps://sqlite.org/cli.html#sqlar
.import commandhttps://sqlite.org/cli.html#csv
.load commandhttps://sqlite.org/cli.html#dotload
SQLITE_DBCONFIG_DEFENSIVEhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigdefensive
SQLITE_DBCONFIG_TRUSTED_SCHEMAhttps://sqlite.org/c3ref/c_dbconfig_defensive.html#sqlitedbconfigtrustedschema
tclshhttps://www.tcl.tk/man/tcl8.3/UserCmd/tclsh.htm
zlib compression libraryhttps://zlib.net
.archive commandhttps://sqlite.org/cli.html#sqlar
.archive commandhttps://sqlite.org/cli.html#sqlar
zlib source codehttps://zlib.net
src/shell.c.inhttps://sqlite.org/src/file/src/shell.c.in
Compilehttps://sqlite.org/howtocompile.html
sqlite3 library source codehttps://sqlite.org/amalgamation.html
-DSQLITE_THREADSAFE=0https://sqlite.org/compile.html#threadsafe
-DSQLITE_ENABLE_EXPLAIN_COMMENTShttps://sqlite.org/compile.html#enable_explain_comments
-DSQLITE_HAVE_ZLIBhttps://sqlite.org/compile.html#have_zlib
-DSQLITE_INTROSPECTION_PRAGMAShttps://sqlite.org/compile.html#introspection_pragmas
-DSQLITE_ENABLE_UNKNOWN_SQL_FUNCTIONhttps://sqlite.org/compile.html#enable_unknown_sql_function
-DSQLITE_ENABLE_STMTVTABhttps://sqlite.org/compile.html#enable_stmtvtab
-DSQLITE_ENABLE_DBPAGE_VTABhttps://sqlite.org/compile.html#enable_dbpage_vtab
-DSQLITE_ENABLE_DBSTAT_VTABhttps://sqlite.org/compile.html#enable_dbstat_vtab
-DSQLITE_ENABLE_OFFSET_SQL_FUNChttps://sqlite.org/compile.html#enable_offset_sql_func
-DSQLITE_ENABLE_JSON1https://sqlite.org/compile.html#enable_json1
-DSQLITE_ENABLE_RTREEhttps://sqlite.org/compile.html#enable_rtree
-DSQLITE_ENABLE_FTS4https://sqlite.org/compile.html#enable_fts4
-DSQLITE_ENABLE_FTS5https://sqlite.org/compile.html#enable_fts5

Viewport: width=device-width, initial-scale=1.0


URLs of crawlers that visited me.