hello,
how can one add a new build system so he would be able to run a sql-scripts?
thanks in advance!
A new build sql system
sanss
#1
0 Likes
kingkeith
#2
you may want to try installing an existing package rather than manually defining a build system (something we can’t help you with because you haven’t told us how you would connect to the database (or even which type it is) and execute SQL statements from the command line)
https://packagecontrol.io/packages/SQLTools
https://packagecontrol.io/packages/SQLExec
0 Likes
sanss
#3
i already installed SQLTools. i do not want to connect to some database, i just want to create my own database to drill the sql language. now i want to run the following .sql script:
indent preformatted text by 4 spaces
CREATE TABLE friends (id INTEGER PRIMARY KEY, name TEXT, gender TEXT, adress TEXT);
INSERT INTO friends VALUES (1, donny, female, basel);
INSERT INTO friends VALUES (2, james, male, bern);
how can i run this sql-script so the rows of this sql-table to appear in some execution field? should’n i set the biuld system to some sql-build system.
0 Likes
rwols
#4
You will still need to run a database server on your local machine to play around with. You and your scripts are the client. You can run a PostgreSQL database server with docker, for instance.
0 Likes