How to Install and Get Started with SQLite on Windows and Mac Computer
How to Install and Get Started with SQLite on Windows and Mac Computer
SQL Download page
https://www.sqlite.org/download.html
SQLite Download instructions for windows and Mac.
Windows Machine SQLite Installation Instructions.
- Download sqlite from download page
- Unzip file
- Use terminal to navigate to the location of the file
- Enter code “winpty ./sqlite3.exe”
- If sqlite is downloaded, you should see a sqlite command that looks like “sqlite>”
- Test your new sqlite installation by typing “newdb.sqlite”. You should see something that looks like “…>” that means you are ready to create a new sqlite database and your installation is successful.
- Then enter these two lines of code to first create an alias for sqlite3 so that you can call up sqlite 3 by simply typing sqlite3 on your command line. Then the second code adds sqlite3 to your computer path variable.
- echo “alias sqlite3=\”winpty ${PWD}/sqlite3.exe\”” >> ~/.bashrc
- Then
- source ~/.bashrc
- Then refresh terminal by typing “clear” to start using sqlite
- Then type “sqlite3” and you should once again be presented with a “sqlite>” command line.
- Then search for sqlite on your apps and you should see the app for sqlite. With the sqlite software, you can do sqlite work or you can use your terminal to do sqlite work by typing in “sqlite3” on your terminal at any time.
Mac Machine SQLite Installation Instructions.
- Download sqlite from download page
- Unzip file
- Use terminal to navigate to the location of the file
- Enter code “mv sqlite3 /usr/local/bin/”
- If sqlite is downloaded, you should see a sqlite command that looks like “sqlite>”
- Test your new sqlite installation by typing “newdb.sqlite”. You should see something that looks like “…>” that means you are ready to create a new sqlite database and your installation is successful.
- Whenever you type “sqlite3” and you should once again be presented with a “sqlite>” command line.
- Then search for sqlite on your apps and you should see the app for sqlite. With the sqlite software, you can do sqlite work or you can use your terminal to do sqlite work by typing in “sqlite3” on your terminal at any time.
Leave a Comment