Home - News ( United States | United Kingdom | Italy | Germany ) - Football scores

Showing content from https://datastation.multiprocess.io/docs/tutorials/Query_SQLite_with_DataStation.html below:

Querying SQLite with DataStation | DataStation

If you want to follow along with this tutorial verbatim, in your terminal create a SQLite database and enter this sample data:

$ sqlite3 ~/test.sqlite
SQLite version 3.36.0 2021-06-18 18:58:49
Enter ".help" for usage hints.
sqlite> create table test(name text, age int);
sqlite> insert into test values ('Kara', 24), ('Mike', 30);

Now inside DataStation, create a new data source in the left sidebar.

Give it a nice name so you easily can find it later. And select SQLite in the Vendor dropdown.

In the database field, specify the file

Next set your database, username, and password.

If you want connect to a SQLite database on a remote server, you will need to set up the SSH connection to that server first. Once you do, you can select that connection in the "Via Server" dropdown.

Now create a new panel and select the Database type.

Enter your query and hit play!

Note: Ctrl-r is a shortcut for hitting the play button when you are focused on one panel.

You can always download the results of a panel by hitting the download button. Or you can reference the results in other panels.

There is a graph button below the query panel, beside the New Panel button. Click it to generate a graph panel pointed at the query panel.

See an error or want to add a clarification? This page is generated from this file on Github.

Last edited Apr 06, 2022.

RetroSearch is an open source project built by @garambo | Open a GitHub Issue

Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo

HTML: 3.2 | Encoding: UTF-8 | Version: 0.7.4