Adding a Datastore after install (Beta)

[CoreyC]

For those of you wanting to use multiple data stores you don't have to
wait for this feature.

I have only tested this with MySQL - I am sure the process is similar
for other DBMS's

Execute a query similar to below:

// Begin SQL
INSERT INTO `YOUR_STUDIO_DB`.`datastore` (
`name` ,
`type` ,
`ogrstring`
)
VALUES (
NULL , 'store_name', 'postgis', 'alchemy_string'
);
// eo

YOUR_STUDIO_DB: Of course replace this with the name of your database.
name : The human readable name displayed in Studio.
type : I don't think this is exactly important, just used for
description purposes.
ogrstring: This should be a properly formatted sqlAlchemy string as
detailed in studio.ini

Feel free to improve or expand.

[Eric Lemoine]

Thanks for sharing this. This is indeed a way to work with current datastores.

--
Eric Lemoine

Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac, Cedex

Tel : 00 33 4 79 44 44 96
Mail : eric.l...@camptocamp.com
http://www.camptocamp.com