Working with SQLiteStudio
|
In many desktop scenarios, using a RDBMS server proves to be overkill and can even cause security problems in case of misconfiguration. If only one user with one application needs access to the data, the SQLite database gives you an option, without having to do without the benefits of the query language (see box "SQLite").
SQLiteStudio [1] turns out to be a compact and useful tool, giving users the ability to easily accomplish many daily tasks related to SQLite databases. To discover how to set up the practical application quickly, refer to the "Installing SQLiteStudio" box.
Creating a Database
To create a new database, launch SQLiteStudio and then click Database | Add a database or simply type Ctrl+O. In the dialog box that appears (Figure 1), choose SQLite 3 as the Database type . In File , click on the green plus sign to the right of the input box to create a data directory.
[...]
Buy this article as PDF
Pages: 7
(incl. VAT)
Buy Ubuntu User
US / Canada
UK / Australia
Related content
-
Visualizing complex structures using Graphviz
Network plans, nested dependencies, or binary trees – with Graphviz, you can visualize complex relationships in a simple way.
-
Getting started with LibreOffice Base
Creating database applications with wizards and graphic editors – without SQL and programming – that's what the LibreOffice program Base, modeled after Microsoft Access, is all about.
-
LibreOffice Base
A database without a search function is like a car without an engine. The second part of our Base series is dedicated to implementing a database search.
-
Convenient private cloud with Seafile
After the Prism and Tempora revelations, the writing's on the wall: Your data stored on public clouds isn't safe from the clutches of security agencies. Help can come only from a self-administered solution – yet Seafile provides a simple and ingenious approach.
-
Installing and testing Nextcloud
Leading ownCloud developers, including the project founder Frank Karlitschek, became dissatisfied with the direction of the project, so they started Nextcloud, a fork of the code and a new company. The goal is to create a better balance among the company, clients, and users. We take a look at how Nextcloud is faring.