yucatan Posted November 10, 2010 Share Posted November 10, 2010 Hello guys i wanne make a sqlite server from oure company. how should i do that. is sqlite for local of for network. if i wanne use netwerk should i manualy send the data over tcp ip? or how can this be done? Greetz Yucatan Link to comment Share on other sites More sharing options...
PsaltyDS Posted November 10, 2010 Share Posted November 10, 2010 SQLite does not use a back-end server process, each client will simply run their own process and access the database file over the network. File locking a simultaneous access are weak spots for SQLite, so you might want a real SQL Server instead, like PostgreSQL or MySQL for free, or MS SQL for cost. Valuater's AutoIt 1-2-3, Class... Is now in Session!For those who want somebody to write the script for them: RentACoder"Any technology distinguishable from magic is insufficiently advanced." -- Geek's corollary to Clarke's law Link to comment Share on other sites More sharing options...
willichan Posted November 10, 2010 Share Posted November 10, 2010 If you want to share SQLite over the network, you can use File Locking with Cooperative Semaphores to do it. You won't need to run any server side services to do it. The clients will cooperate amongst themselves. My UDFs: Barcode Libraries, Automate creation of any type of project folder, File Locking with Cooperative Semaphores, Inline binary files, Continue script after reboot, WinWaitMulti, Name Aggregator, Enigma, CornedBeef Hash Link to comment Share on other sites More sharing options...
yucatan Posted November 11, 2010 Author Share Posted November 11, 2010 SQLite does not use a back-end server process, each client will simply run their own process and access the database file over the network. File locking a simultaneous access are weak spots for SQLite, so you might want a real SQL Server instead, like PostgreSQL or MySQL for free, or MS SQL for cost.hello is mysql supported by autoit.or is there a good udf that i can use to het autoit send quesry's to a mysql server? Link to comment Share on other sites More sharing options...
willichan Posted November 11, 2010 Share Posted November 11, 2010 hello is mysql supported by autoit.or is there a good udf that i can use to het autoit send quesry's to a mysql server? My UDFs: Barcode Libraries, Automate creation of any type of project folder, File Locking with Cooperative Semaphores, Inline binary files, Continue script after reboot, WinWaitMulti, Name Aggregator, Enigma, CornedBeef Hash Link to comment Share on other sites More sharing options...
Habland0 Posted November 14, 2010 Share Posted November 14, 2010 I would say that UDF is superseded by Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now