If you have an account (see register), and have logged in
(see login), you will be able to create your own databases.
Create a database
- Go to the page showing your databases
("My databases" in the top menu.)
- Click Create.
- Provide a name for the database to create. The rules for a name are given
in the help text.
- The title and descriptions are optional, but obviously useful for
describing what the data is about.
- Clicking Create will create the database and bring you to its page.
Upload a database
- Go to the page showing your databases ("My databases"
in the top menu.)
- Click Upload.
- Select the file to upload from your local computer, and optionally
specify a new name for the database.
- Clicking Upload SQLite3 file will upload it and the server will
interpret the contents to extract the schema of the tables.
- It is also possible to upload an XLSX file (Excel). The server will
try to interpret the contents as best as it can, and create a table
for each worksheet.
The database page
- The database page is initially empty since no tables of views have been
created.
- The buttons on the right show which operations are available. Some of the
buttons display brief explanatory messages when hovering the mouse over them.
- Above the buttons are different download options.
- Below the buttons is some meta-information about the database.
Create a table
- On the database page, click Create table.
- Provide a name for the table.
-
A maximum of 8 columns can be defined in this interface.
- Provide the column name.
- Choose which data type the column should have.
- Decide if the column should be a primary key. Only one column
can be set as primary key in this interface.
- Decided if the column should be "NOT NULL", i.e. require a value.
- Click Create. The table is created and its rows page is shown.
- Click Schema to verify that the table definition is what you expect.
- On this page, the buttons Add column and Create index can be used.
Upload a CSV file to create a table
- A table can also be created by uploading a CSV (Comma-Separated
Values) file. Such files can either by created "by hand", or by
exporting a spreadsheet from Excel.
- In the database page, click Upload table.
- The page has input fields for the file itself, and for some details
about the file layout. It is recommended to ensure that the CSV file
contains a header record. If it exists, it must contain the names of
the columns.
- The upload process infers the schema for the table from the contents
of the CSV file.