SQLite_server

Remote SQLite and commands tool. (based on python-osc, so pip install that first!)

This tool allows to connect and perform queries to a SQLite database on any remote computer. (PC, Mac, Raspberry Pi).

The tool also can be used to execute commands on the remote system. A SQLite config database is used that should contain all the names and IP adresses of the systems (in table nodes)

1. Download all files to one machine.
2. Enter the names and IP addresses of all systems you want to connect to (with a SQLite tool, like FireFox) in table nodes
3. Copy all files (including the modified config.sqlite) to all relevent systems
4. On the system that should be the SQLite server, edit oscommand.py name variable to point to the client
5. Run oscommand.py on the server.
6. On the client system, edit OscQLiteCli.py and SQLiteClient.py name variable to point to the server
7. Run OscQliteCli.py or SQLiteClient.py (see NOTE) on the client.

With OscQliteCli you can execute commands and SQL commands on the server, like 'dir', or 'cd ..'.

SQL commands should start with 'SQL@', e.g. 'SQL@select * from employees'

('employees' is an example table in the 'remote' SQLite database. You can add tables the normal way, e.g. 'SQL@CREATE TABLE tablename ...' )

NOTE: SQLiteClient is a client class that can be used in your program, in contrast to OscQliteCli, that is command line interpreter.