Page 1 of 1
Maximum user number increase using SQLite
Posted: 22 Apr 2022, 02:01
by vk5rj
Hello,
Is it possible to increase the maximum number of users allowable in the SQLite database, and if so, how is it done?
Alternatively, is it possible to import all the users currently in the SQLite database into a MYSQL database after a new on e is created?
Thanks,
John K (vk5rj)
Re: Maximum user number increase using SQLite
Posted: 22 Apr 2022, 06:42
by G4POP
vk5rj wrote: 22 Apr 2022, 02:01
Hello,
Is it possible to increase the maximum number of users allowable in the SQLite database, and if so, how is it done?
Alternatively, is it possible to import all the users currently in the SQLite database into a MYSQL database after a new on e is created?
Thanks,
John K (vk5rj)
SQLite has no concept of user accounts, and instead relies on the file system for all database permissions.
MySQL stores accounts in the user table of the mysql system database. An account is defined in terms of a user name and the client host or hosts from which the user can connect to the server.
As stated above SQLite only provides for one user so your last question is not applicable.
Or do you not really mean 'Users' but something else entirely? like Owner, station or Operator call sign?
Re: Maximum user number increase using SQLite
Posted: 22 Apr 2022, 23:23
by vk5rj
Sorry, users is the wrong term.
I meant limited number of callsigns/stations/QSOs recorded in the database.
At the moment it shows that there is a limit of 5000 entries in the database.
Sorry for the lack of clarity in the question.
73s
John
Re: Maximum user number increase using SQLite
Posted: 23 Apr 2022, 01:46
by KI5IO
vk5rj wrote: 22 Apr 2022, 23:23
Sorry, users is the wrong term.
I meant limited number of callsigns/stations/QSOs recorded in the database.
At the moment it shows that there is a limit of 5000 entries in the database.
Sorry for the lack of clarity in the question.
73s
John
John,
Your reply gives me a clue that you have not taken the time to read /review the very detailed and extensive User Guide that we provide with Log4OM V2.
Please download the current User Guide and turn to Page 29. You will see an explanation of that initial 5000 count value, what it stands for, how you can adjust it, etc., etc..
The initial / default setting is 5000 and that is the number of records being "displayed" ... NOT THE NUMBER OF RECORDS (QSOs) IN THE DATABASE.
Again ... it will serve you well to take the time to go through the User Guide. It has a wealth of information.
Re: Maximum user number increase using SQLite
Posted: 23 Apr 2022, 04:12
by vk5rj
Thanks for you reply. I will look it up.
Regards,
John