SqueakDBX

The relational access answer for Squeak/Pharo

Database scripts

PostgreSQL

—Login as administrator. Default is: sudo -u postgres psql

CREATE DATABASE sodbxtest;

CREATE USER sodbxtest;

ALTER USER sodbxtest PASSWORD ’sodbxtest’;

GRANT ALL PRIVILEGES ON DATABASE sodbxtest to sodbxtest;



MySQL

—Log in as administrator: example.: mysql -u username -p

CREATE DATABASE sodbxtest;

CREATE USER sodbxtest IDENTIFIED BY ’sodbxtest’;

GRANT ALL ON *.* TO sodbxtest;

    • Sign out and then sign in with user sodbxtest: mysql -u sodbxtest -p
    • Change to the recently created database

USE sodbxtest;



Oracle

    • we are using oracle-xe, so we will work on XE database because its does not permit create another DATABASE.
    • Login as administrator

sqlplus sys as sysdba;

    • create user

CREATE USER sodbxtest IDENTIFIED BY sodbxtest;

GRANT ALL PRIVILEGES TO sodbxtest;



Sqlite3

 For Sqlite you only have to create a database from commandline. You could do something like this: $ sqlite3 sodbxtest.db Remember to change sqliteFacility class method in DBXXBackendFacility