TheDeveloperBlog.com

Home | Contact Us

C-Sharp | Java | Python | Swift | GO | WPF | Ruby | Scala | F# | JavaScript | SQL | PHP | Angular | HTML

SQLite Installation

SQLite Installation with history, features, advantages, installation, commands, syntax, datatypes, operators, expressions, databases, table, crud operations, clauses, like, glob, limit, and clause, advance sqlite

<< Back to SQLITE

SQLite Installation

SQLite is known for its zero configuration which means no complex setup or administration is required. Let's see how to install SQLite on your system.


Install SQLite on Windows

Follow the steps given below:

  • Go to SQLite official website download page http://www.sqlite.org/download.html And download precompiled binaries from Windows section.
SQLite Installation 1
  • Download the sqlite-dll and sqlite-shell zip file. Or sqlite-tools-win32-x86-3170000.zip file.
  • Create a folder named sqlite in C directory and expand these files.
SQLite Installation 2
  • Open command prompt to set the path. Set your PATH environment variable and open sqlite3 command. It will look like this:
SQLite Installation 3

The above method facilitates you a permanent way to create database, attach database and detach database.

There is another way to execute CRUD operation in SQLite. In this method, there is no need to set a path.

  • Just download the SQlite precompiled Binary zip file.
  • Expand the zipped file, you will see a page like this:
SQLite Installation 4
  • Run the selected sqlite3 application:
SQLite Installation 5 SQLite Installation 6

You can execute the SQLite query here. But here, the data is temporary and once you shut down your computer, you will lose the records you have. Because, you cannot create, attach or detach a database here.


Next TopicSQLite Commands




Related Links:


Related Links

Adjectives Ado Ai Android Angular Antonyms Apache Articles Asp Autocad Automata Aws Azure Basic Binary Bitcoin Blockchain C Cassandra Change Coa Computer Control Cpp Create Creating C-Sharp Cyber Daa Data Dbms Deletion Devops Difference Discrete Es6 Ethical Examples Features Firebase Flutter Fs Git Go Hbase History Hive Hiveql How Html Idioms Insertion Installing Ios Java Joomla Js Kafka Kali Laravel Logical Machine Matlab Matrix Mongodb Mysql One Opencv Oracle Ordering Os Pandas Php Pig Pl Postgresql Powershell Prepositions Program Python React Ruby Scala Selecting Selenium Sentence Seo Sharepoint Software Spellings Spotting Spring Sql Sqlite Sqoop Svn Swift Synonyms Talend Testng Types Uml Unity Vbnet Verbal Webdriver What Wpf