Basic Questions about SQL usage with multiple users
0
For a science project we need to use a database with multiple users in different places. At the moment we use SQLite for testing. But as we are pretty new to the whole Database world there are some question and concerns about what and how we need to use SQLite.
- I read about that it is okay to use SQLite with multiple users. I also read that WAL mode would be great if we have a lot of read processes – what we do have. Is that right?
- In the final stages every user has to gain access via the internet to our Databases. What is the best way to provide that? Is SQLite able to do that? Or do we Need tu use SQL Server or anything like that?
- If multiple users use a DB, there could be the case that two users want to write at the same moment, but then the DB is locked from one user for a few milliseconds. We are working with Python at the moment, is there a good way to check if a DB is locked and try it again after a few milliseconds? Or is there another, better way to prevent a user trying to access a locked DB?
I hope it is okay to keep my questions a little bit wide. If I have to change anything in my question or additional information is needed, please let me know! Thank you.
sql-server performance sqlite
asked 18 mins ago
mk1337mk1337
11
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
add a comment |
0
For a science project we need to use a database with multiple users in different places. At the moment we use SQLite for testing. But as we are pretty new to the whole Database world there are some question and concerns about what and how we need to use SQLite.
- I read about that it is okay to use SQLite with multiple users. I also read that WAL mode would be great if we have a lot of read processes – what we do have. Is that right?
- In the final stages every user has to gain access via the internet to our Databases. What is the best way to provide that? Is SQLite able to do that? Or do we Need tu use SQL Server or anything like that?
- If multiple users use a DB, there could be the case that two users want to write at the same moment, but then the DB is locked from one user for a few milliseconds. We are working with Python at the moment, is there a good way to check if a DB is locked and try it again after a few milliseconds? Or is there another, better way to prevent a user trying to access a locked DB?
I hope it is okay to keep my questions a little bit wide. If I have to change anything in my question or additional information is needed, please let me know! Thank you.
sql-server performance sqlite
asked 18 mins ago
mk1337mk1337
11
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
every user has to gain access via the internet to our Databases. Extremely bad. Be ready to loose your data. Think about some server-side application (with proper authentication) for accessing to your DB, web-interface, for example.
– Akina
13 mins ago
Thanks for your answer. We do have Python Tools locally creating data, then inserting them to a DB. But each user is at an different place. Is it really necessary to have an Web-Interface doing that? No local Tools?
– mk1337
6 mins ago
add a comment |
0
0
0
For a science project we need to use a database with multiple users in different places. At the moment we use SQLite for testing. But as we are pretty new to the whole Database world there are some question and concerns about what and how we need to use SQLite.
- I read about that it is okay to use SQLite with multiple users. I also read that WAL mode would be great if we have a lot of read processes – what we do have. Is that right?
- In the final stages every user has to gain access via the internet to our Databases. What is the best way to provide that? Is SQLite able to do that? Or do we Need tu use SQL Server or anything like that?
- If multiple users use a DB, there could be the case that two users want to write at the same moment, but then the DB is locked from one user for a few milliseconds. We are working with Python at the moment, is there a good way to check if a DB is locked and try it again after a few milliseconds? Or is there another, better way to prevent a user trying to access a locked DB?
I hope it is okay to keep my questions a little bit wide. If I have to change anything in my question or additional information is needed, please let me know! Thank you.
sql-server performance sqlite
asked 18 mins ago
mk1337mk1337
11
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
For a science project we need to use a database with multiple users in different places. At the moment we use SQLite for testing. But as we are pretty new to the whole Database world there are some question and concerns about what and how we need to use SQLite.
- I read about that it is okay to use SQLite with multiple users. I also read that WAL mode would be great if we have a lot of read processes – what we do have. Is that right?
- In the final stages every user has to gain access via the internet to our Databases. What is the best way to provide that? Is SQLite able to do that? Or do we Need tu use SQL Server or anything like that?
- If multiple users use a DB, there could be the case that two users want to write at the same moment, but then the DB is locked from one user for a few milliseconds. We are working with Python at the moment, is there a good way to check if a DB is locked and try it again after a few milliseconds? Or is there another, better way to prevent a user trying to access a locked DB?
I hope it is okay to keep my questions a little bit wide. If I have to change anything in my question or additional information is needed, please let me know! Thank you.
sql-server performance sqlite
sql-server performance sqlite
asked 18 mins ago
mk1337mk1337
11
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 18 mins ago
mk1337mk1337
11
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 18 mins ago
mk1337mk1337
11
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
asked 18 mins ago
mk1337mk1337
11
asked 18 mins ago
mk1337mk1337
11
11
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
New contributor
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
mk1337 is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.
every user has to gain access via the internet to our Databases. Extremely bad. Be ready to loose your data. Think about some server-side application (with proper authentication) for accessing to your DB, web-interface, for example.
– Akina
13 mins ago
Thanks for your answer. We do have Python Tools locally creating data, then inserting them to a DB. But each user is at an different place. Is it really necessary to have an Web-Interface doing that? No local Tools?
– mk1337
6 mins ago
add a comment |
every user has to gain access via the internet to our Databases. Extremely bad. Be ready to loose your data. Think about some server-side application (with proper authentication) for accessing to your DB, web-interface, for example.
– Akina
13 mins ago
Thanks for your answer. We do have Python Tools locally creating data, then inserting them to a DB. But each user is at an different place. Is it really necessary to have an Web-Interface doing that? No local Tools?
– mk1337
6 mins ago
every user has to gain access via the internet to our Databases. Extremely bad. Be ready to loose your data. Think about some server-side application (with proper authentication) for accessing to your DB, web-interface, for example.
– Akina
13 mins ago
every user has to gain access via the internet to our Databases. Extremely bad. Be ready to loose your data. Think about some server-side application (with proper authentication) for accessing to your DB, web-interface, for example.
– Akina
13 mins ago
Thanks for your answer. We do have Python Tools locally creating data, then inserting them to a DB. But each user is at an different place. Is it really necessary to have an Web-Interface doing that? No local Tools?
– mk1337
6 mins ago
Thanks for your answer. We do have Python Tools locally creating data, then inserting them to a DB. But each user is at an different place. Is it really necessary to have an Web-Interface doing that? No local Tools?
– mk1337
6 mins ago
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
mk1337 is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229584%2fbasic-questions-about-sql-usage-with-multiple-users%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
mk1337 is a new contributor. Be nice, and check out our Code of Conduct.
draft saved
draft discarded
mk1337 is a new contributor. Be nice, and check out our Code of Conduct.
mk1337 is a new contributor. Be nice, and check out our Code of Conduct.
mk1337 is a new contributor. Be nice, and check out our Code of Conduct.
Thanks for contributing an answer to Database Administrators Stack Exchange!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f229584%2fbasic-questions-about-sql-usage-with-multiple-users%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
every user has to gain access via the internet to our Databases. Extremely bad. Be ready to loose your data. Think about some server-side application (with proper authentication) for accessing to your DB, web-interface, for example.
– Akina
13 mins ago
Thanks for your answer. We do have Python Tools locally creating data, then inserting them to a DB. But each user is at an different place. Is it really necessary to have an Web-Interface doing that? No local Tools?
– mk1337
6 mins ago