Click here to Skip to main content
Click here to Skip to main content

How to create SQLite database with Valentina Studio

, 12 Jul 2014 CPOL
Rate this:
Please Sign up or sign in to vote.
It's the best and simple way to create and manage your SQLite database

Introduction

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. To use SQLite engine, first you need to create a database. You can create it by script in your code, But for the first time, maybe it's hard for you to create a database. This tutorial will give you a quick start with SQLite and Valentina Studio and make you comfortable with creating SQLite database

 

Step 1: Install the Valentina Studio

Valentina Studio is a powerful software to create and manage SQLite database, Although it has many features of MySQL and Postgre. For installing you should go the Valentina Studio website and download the Valentina Studio. After download and install is finished you should get a free license from the website.

 

Step 2:Running the Valentina Studio

As you can see in the below picture the first and main page of software includes three sections. The first column is related to the server configuration that you don't need it

 

Step 3: Create a new database

Now we are ready to create our first database with Valentina Studio. There are two ways to achieve create form in the software. One way is you go to the file menu and select New Database menu item and then select SQLite files.

 

As you can see in this picture, The other way is from the second column of software so select New Database item and then select SQLite.

 

After you select New Database item and then select SQLite, you can see the new window and you should select the name and path of your database that you want to create. Then click on ok to go to the next step.

 

 

After you click on last window Valentina Studio create a new database on your path. But our database is empty now. We should create tables to read and write data. In the next step I will show you how to create them.

 

Step 4: Create new tables

As you can see in the picture there are columns. First column is database column. When you have many databases you can change between them by this column. The second column shows the tables of each database and third column shows the fields of each table. Now, right click over the middle column and select create table to see the table creation window.

 

Step 5: Create new fields

When you click on create new table you can see this window that has many tab containing features to use. First go to the table tab and select the name of new table. Then go to the second tab for declaring new fields.

 

In the second tab you can declare new fields. As you can see, There are 9 types of fields in SQLite that are BLOB, Boolean, Date, DateTime, Double, Integer, Numeric, Real and Text so you can choose between them based your table design.

After defining your fields you can define index and primary key in other tab and save your changes by clicking on Ok button on the buttom of the page.

Points of Interest

I think this is the best and simple way to create your first SQLite database. Also, it's very powerful tools for developers to manage and maintain databases.

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Share

About the Author

Alireza Chegini
Web Developer
Iran (Islamic Republic Of) Iran (Islamic Republic Of)
I like programming because when you design a software you create a thing that improve your life.
Follow on   Twitter   Google+   LinkedIn

Comments and Discussions

 
GeneralMy vote of 5 Pinmemberdeshjibon15-Jul-14 10:16 
GeneralMy vote of 1 PinmemberW. Kleinschmit14-Jul-14 2:40 
AnswerRe: My vote of 1 PinprofessionalAlireza Chegini14-Jul-14 8:56 
QuestionWhat's the purpose of this article? PinmemberW. Kleinschmit14-Jul-14 2:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.

| Advertise | Privacy | Terms of Use | Mobile
Web02 | 2.8.141216.1 | Last Updated 12 Jul 2014
Article Copyright 2014 by Alireza Chegini
Everything else Copyright © CodeProject, 1999-2014
Layout: fixed | fluid