SQLite acceso

HMG en Español

Moderator: Rathinagiri

jparada
Posts: 430
Joined: Fri Jan 23, 2009 5:18 pm

SQLite acceso

Post by jparada »

Hola,

He leído que con SQLite no podemos trabajar en modo multiusuario, pero lo que entiendo que si se puede hacer es que varios usuarios utilicen el mismo archivo de datos pero escriban sobre diferentes tablas, es decir, si tengo una aplicación y van a accesar tres usuarios cada uno de ellos en un módulo especifico de la aplicación, estonces si podría funcionar de manera correcta.

Si esto que entiendo es correcto..., tengo aún así otro problema..., ya que la aplicación la instalaria en un equipo, y los tres usuario mencionados tendrían que accesar de manera remota.

Si estoy equivocado en esto y alguien quiere compartir algo de información/experiencia se lo agradezco.

Saludos,
Javier
jayadevu
Posts: 238
Joined: Tue May 19, 2009 7:10 am

Re: SQLite acceso

Post by jayadevu »

Hi,

Please read the article below:

http://stackoverflow.com/questions/5102 ... tiple-user

Hope that helps,

Warm regards,

Jayadev
jparada
Posts: 430
Joined: Fri Jan 23, 2009 5:18 pm

Re: SQLite acceso

Post by jparada »

Hi,
Multiple processes can have the same database open at the same time. Multiple processes can be doing a SELECT at the same time. But only one process can be making changes to the database at any moment in time, however.
I already read that reference, that's why I assume it is possible to do what I asked..., but I'm just assuming..., so I would ask if anyone has experience with this and may want to share something .

About remote access, I think share the folder or use remote desktop would be enough, but again... I'm just assuming..., I'm still looking for information on the web .

Thanks.

Regards,
Javier
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: SQLite acceso

Post by Amarante »

I have a few small applications running on multi-user mode and that the database and the executable are located in a data server. The amount of information is small and there is not much competition recordings, as the system is basically for research. Despite being accessed by multiple users and there have not been (or I was not informed) no problem.
SQLite is a database for small applications that do not have much conconrrência recording. But it all depends on how it was structured, how users work, everything depends.
------------------------------------------
Eu tenho alguns pequenos aplicativos rodando em modo multiusuário e que o banco de dados e o executável estão localizados em um servidor de dados. A quantidade de informações é pequena e não há muita concorrência de gravações, pois o sistema é basicamente para pesquisa. Apesar de ser acessado por vários usuários e até hoje não houve (ou não me foi informado) nenhum problema.
O SqLite é um banco de dados para pequenas aplicações que não tenham muita conconrrência de gravação. Mas tudo depende de como foi estruturado, como os usuários trabalham, enfim, tudo depende.
User avatar
serge_girard
Posts: 3161
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: SQLite acceso

Post by serge_girard »

You mean concurrent updating?

Serge
There's nothing you can do that can't be done...
User avatar
Amarante
Posts: 182
Joined: Fri Apr 27, 2012 9:44 pm
DBs Used: DBF, MySQL, MariaDB, SQLite, PostgreSQL
Location: Araruama-RJ, Brazil

Re: SQLite acceso

Post by Amarante »

serge,
Test with the application of DSQL
http://hmgforum.com/viewtopic.php?f=37&t=4293#p40722
good luck
User avatar
serge_girard
Posts: 3161
Joined: Sun Nov 25, 2012 2:44 pm
DBs Used: 1 MySQL - MariaDB
2 DBF
Location: Belgium
Contact:

Re: SQLite acceso

Post by serge_girard »

I have for several years now a large numbers of MySQL app's running, partly under HMG and partly on the web.
It runs without problems.

S
There's nothing you can do that can't be done...
User avatar
Rathinagiri
Posts: 5471
Joined: Tue Jul 29, 2008 6:30 pm
DBs Used: MariaDB, SQLite, SQLCipher and MySQL
Location: Sivakasi, India
Contact:

Re: SQLite acceso

Post by Rathinagiri »

SQLite can't handle concurrent writing a lot. It can handle easily concurrent read.
East or West HMG is the Best.
South or North HMG is worth.
...the possibilities are endless.
User avatar
Ismach
Posts: 161
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina

Re: SQLite acceso

Post by Ismach »

Aqui un ejemplo... ;)
Attachments
IsmachSQLiteejemplo.zip
(2.12 MiB) Downloaded 255 times
User avatar
Ismach
Posts: 161
Joined: Wed Nov 28, 2012 5:55 pm
DBs Used: DBF, mySQL, Mariadb, postgreSQL, Oracle, Db2, Interbase, Firebird, and SQLite
Location: Buenos Aires - Argentina

Re: SQLite acceso

Post by Ismach »

SQLite es un Base de Datos Relacional ( ANSI SQL ) creada para cualquier aplicacion monousuario, como por ejemplo
un navegador, Firefox usa SQL, sistemas de mensajeria, cualquier aplicacion para telefonos moviles/tablets etc etc usan esta base de datos
si quieren una ejemplo

Firefox usa SQL en el caso de Firefox tiene:
en %APPDATA%\Mozilla\Firefox\Profiles\tpgbxoks.default\
places.sqlite
places.sqlite-wal (temporal)
cookies.sqlite
webappsstore.sqlite
healthreport.sqlite

SQLite es IDEAL para aplicaciones en Dispositivos moviles (MonoUsuario)
Post Reply