![]() ![]() Now select the users table from the marked section of the screenshot below. Now I will show you how to insert data into the users table.įirst go to the Browse Data tab as marked in the screenshot below. Once you’re happy with your table, click on OK. SQLite Browser is an awesome tool to lean SQLite as well. You can run this code in the SQLite 3 command line interface and create an identical users table as well. In the marked section of the screenshot below, you can find the SQL code. I added name and country field, set their Type to TEXT and checked the Not null checkboxes. ![]() ![]() I named the field id, changed the Type to INTEGER, checked the Not null, PK (Primary Key), AI (Auto Increment) checkboxes. Once you click on Add field button, you should see a new field as marked in the screenshot below. Now you can click on Add field button to add as many fields or columns on your table. If you want to follow along, users table it is. Using this window, you can create your first SQLite 3 table.Įnter the name of the table. Type in a filename and save it somewhere on your filesystem. You should see the following dialog window. In this section, I will show you the basics of SQLite 3 database with SQLite Browser graphical user interface.įirst click on New Database to create a new database using SQLite Browser. Getting Started with SQLite 3 using SQLite Browser SQLite Browser should start as you can see in the screenshot below. You should see a database icon as marked in the screenshot below. SQLiteman Manual – Official usage guide, recommended to read if you need some help regarding this tool.Now you can go to the Application Menu and search for SQLite Browser. Install SQLiteman in Ubuntu 11.10/12.04įire up a terminal and execute the command (and of course you will have to enter the password, as you are using sudo to gain administrator privileges) – sudo apt-get install sqliteman So in Ubuntu, Linux Mint you can get it from Software Center or synaptic package manager, otherwise use command line tool such as apt-get or aptitude. It’s a free software, available for all platforms, in Ubuntu or most of the GNU/Linux distributions you can find it in the official package repository. SQLiteman is database admin tool for sqlite3 database and of course it has easy to use graphical interface. There are many GUI tools for SQLite databse but SQLiteman seems to be a good one. So having a graphical browser for SQLite database seems a good idea. If you are using Ubuntu as a development platform where it’s a Rails Apps or Android Apps or something else, you may need to browse/analyze database visually using GUI tool. ![]() Due to its small size and efficiency, it is now one of the most popular database engine (Android Apps uses SQLite database for handling persistence data). SQLite is a light weight, fast, easy to use (because no configuration or setup is required, it just works!) SQL Database Engine. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |