Adobe Community: Signle SQLite db to all app users

Currently Being Moderated

1. yang.liu,

Mar 8, 2011 10:37 PM in reply to macbuc

Report

Hello,

When openning a database with SQLConnection, you can specify the location of the database as the first parameter of the open function. So if the location of the database can be accessed by all system users, these users can share the data in the database. Please try with the following code:

var dbFile:File = new File("c:\\test.db");

var conn:SQLConnection = new SQLConnection();

conn.open(dbFile,SQLMode.CREATE);

Any problem, please feel free to let us know.

Thanks,

Yang

|

Mark as:

Currently Being Moderated

2. Brister1,

Mar 9, 2011 10:35 AM in reply to yang.liu

Report

How does this work if the apps are running concurrently? I can't imagine that it properly handles multiple writer connections from different processes does it? (if so I'll be happily surprised, but given how poorly it handles multple writer connections in the same process I'd be shocked)

|

Mark as:

Currently Being Moderated

3. yang.liu,

Mar 9, 2011 7:23 PM in reply to Brister1

Report

Multiple apps can not concurrently access a single SQLite database. SQLite will lock the whole database file when reading or writing data. This guarantees the safe access to SQLite in multiple-user environment.

Thanks,

Yang

|

Mark as:

Currently Being Moderated

4. macbuc,

Mar 10, 2011 2:23 PM in reply to yang.liu

Report

The problem is that I need to create a folder where put the db and this folder need write privileges for all users. Can I do that from AIR?

I try to create the db in the app folder ex: app:mydata.db but when I try the app in win7 I need to manually set write privileges to the app folder... my app have to run on mac and linux also. I need a way to manage access privileges in all os and inform the user that he need the admin privileges to do some operations...

|

Mark as:

Currently Being Moderated

5. yang.liu,

Mar 11, 2011 1:58 AM in reply to macbuc

Report

Could you try with the following code?

    var dbFolder:File = File.applicationStorageDirectory.resolvePath("db");
    dbFolder.createDirectory();
    var dbFile:File = dbFolder.resolvePath("test.db");
    var conn:SQLConnection = new SQLConnection();
    conn.open(dbFile,SQLMode.CREATE);

Hope this could help!

|

Mark as:

Currently Being Moderated

6. macbuc,

Mar 12, 2011 2:36 AM in reply to yang.liu

Report

The problem is that the applicationStorageDirectory isn't relative to the application but is relative to the user, isn't true?

So if many users use the application every user have a own database and this is exactly what I don't want I need a db in a folder where all the users can access and write it but I haven't a way to create this folder by air. So I need an application storage folder relative to the application not to the user.

|

Mark as:

8,532 posts
May 4, 2010

Currently Being Moderated

7. Chris Campbell,

Mar 14, 2011 10:44 AM in reply to macbuc

Report

Unfortunately, on Windows Vista and 7 writing to the program files directory requires elevated privledges. Is it possible you could prompt the user for a shared location? Or, maybe go up to the root of the C: drive and create a new folder?

Chris

|

Mark as:

Currently Being Moderated

8. macbuc,

Mar 14, 2011 1:25 PM in reply to Chris Campbell

Report

I think that I will develop an installation program that create a new folder with write priviledges for all the system users. The problem is that I have to develop a native installer for every system. It could be very usefull in future release of AIR if we can add custom operation in the installation program like setting folder priviledges.

|

Mark as:

AIR Bugs and Performance Issues

Signle SQLite db to all app users

Mar 5, 2011 5:32 AM

More Like This

Bookmarked By (0)

Answers + Points = Status