sqlite database, multiple requests

Question

I'm using the 1-file version of this project: http://php-login.net

It uses a sqlite *.db file to store the info.

Will it cause issues if two users are trying to register at the same time? Permission errors, etc.? I'm unsure how PHP handles multiple requests happening at once.

Just set a primary key, or set a column as UNIQUE.

Funk Forty Niner
– Funk Forty Niner

2014-12-15 16:32:09 +00:00
Commented Dec 15, 2014 at 16:32 — Funk Forty Niner
– Funk Forty Niner, Commented Dec 15, 2014 at 16:32
I'd hope the library he's chosen is doing that already.

quickshiftin
– quickshiftin

2014-12-15 16:34:51 +00:00
Commented Dec 15, 2014 at 16:34 — quickshiftin
– quickshiftin, Commented Dec 15, 2014 at 16:34
@quickshiftin OP should be all set then ;)

Funk Forty Niner
– Funk Forty Niner

2014-12-15 16:37:28 +00:00
Commented Dec 15, 2014 at 16:37 — Funk Forty Niner
– Funk Forty Niner, Commented Dec 15, 2014 at 16:37
possible duplicate of sqlite3 concurrent access

quickshiftin
– quickshiftin

2014-12-16 17:14:20 +00:00
Commented Dec 16, 2014 at 17:14 — quickshiftin
– quickshiftin, Commented Dec 16, 2014 at 17:14

quickshiftin · Accepted Answer · 2014-12-15 16:36:55Z

2

It will work just fine. PHP runs inside of webservers that handle the work of multiple simultaneous requests. SQLite is also capable of handling multiple simultaneous requests, albeit not as many as a propers SQL server like MySQL.

EDIT

I just checked... The one-file version of PHP-login does have a primary key.

$sql = 'CREATE TABLE IF NOT EXISTS `users` (
        `user_id` INTEGER PRIMARY KEY,
        `user_name` varchar(64),
        `user_password_hash` varchar(255),
        `user_email` varchar(64));
        CREATE UNIQUE INDEX `user_name_UNIQUE` ON `users` (`user_name` ASC);
        CREATE UNIQUE INDEX `user_email_UNIQUE` ON `users` (`user_email` ASC);
        ';

edited Dec 15, 2014 at 16:36

answered Dec 15, 2014 at 16:31

quickshiftin

70.4k12 gold badges72 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Funk Forty Niner Over a year ago

Using a PK is what OP should use.

quickshiftin Over a year ago

Pay a little more attention my man, he's using a library that already provides an FK!

Funk Forty Niner Over a year ago

I don't have to "pay more attention". As if I'm going to go through every single link an OP posts to see whether or not he/she did use the actual SQL included in there. So, we don't know that for sure, now do we? There you go. Without even checking that link, my first comment to the OP "answered" the question. Why even put in an "answer"?

quickshiftin Over a year ago

I don't think your comment did answer the question, in fact I think it brought up an unrelated subject... And anyway, you can see in 2 seconds that there is a PK already defined lol, so yes, pay more attention.

Ben Over a year ago

thanks both of you! :) i didn't know sqlite could handle multiple requests - i didn't know if it'd be like two users trying to edit a Word file on a local network share.

|

Collectives™ on Stack Overflow

sqlite database, multiple requests

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related