Getting Started
Introduction to datasquirel. Read the quick-start guide to get started with a new account.
Overview
Datasquirel is an SQL-based data management system that aims to manage SQL databases with the lowest level of opinionation. Datasquirel consists of 2 main parts:
- A full-fledged SQL server that runs multiple isolated databases for different users, interfacing with an online Graphical user interface and a REST API integration.
- An all-purpose static files server using NGINX to serve static files on demand. Files uploaded to datasquirel static file server are public by default, but the can be made private, in which case they can only be accessed via secure encrypted credentials.
Datasquirel's Graphical User Interface aims to narrow down the the complexities of SQL to a simple user interface with columns, rows, and entries.
Datasquirel's API reference uses our NPM module datasquirel. This can be installed via npm:
npm install datasquirel
Learn more by reading the api documentation
Key Concepts
SQL
SQL stands for "Sequential Query language". This is the standard language for relational databases like MySQL and Postgres. Datasquirel uses MySQL and is compatible with all known SQL syntax.
Database
A database in datasquirel is an isolated MySQL database running on our MySQL servers. A database consists of tables, which in turn consists of columns, rows, and entries. Each database can be exported at anytime, and also populated using a .sql dump file at any time.
CRUD
CRUD stands for Create, Read, Update, Delete. This is the basic spectrum of the capabilities of any database, and it is useful for managing data.