Click here to Skip to main content
15,850,298 members
Home / Discussions / Database
   

Database

 
QuestionRe: SQL behind the scenes Pin
Eddy Vluggen10-Feb-24 11:08
professionalEddy Vluggen10-Feb-24 11:08 
QuestionSql Server Database goes into Recovery mode Pin
Nilesh M. Prajapati17-Nov-23 18:59
Nilesh M. Prajapati17-Nov-23 18:59 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Andre Oosthuizen18-Nov-23 8:35
mveAndre Oosthuizen18-Nov-23 8:35 
AnswerRe: Sql Server Database goes into Recovery mode Pin
Mycroft Holmes18-Nov-23 12:38
professionalMycroft Holmes18-Nov-23 12:38 
AnswerRe: Sql Server Database goes into Recovery mode Pin
CHill6020-Nov-23 5:10
mveCHill6020-Nov-23 5:10 
AnswerRe: Sql Server Database goes into Recovery mode Pin
jschell20-Nov-23 8:48
jschell20-Nov-23 8:48 
QuestionSQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 13:23
professionalRichard Andrew x6410-Nov-23 13:23 
AnswerRe: SQLite Thread Safety Pin
Gerry Schmitz10-Nov-23 15:04
mveGerry Schmitz10-Nov-23 15:04 
It's "rereads" that are (usually) the problem. If one is writing, and another reading, one for one makes little difference; if the record aren't related. On the other hand, if you're not writing "complete" records at one time, then they have to be "locked".

For "rereads" you have to check for "dirty" (e.g. timestamp changes). "Screen data has been updated".

With related records, you may need need to lock a table or the entire DB (for a very short time).

All calls should be async to avoid UI waits.


"Before entering on an understanding, I have meditated for a long time, and have foreseen what might happen. It is not genius which reveals to me suddenly, secretly, what I have to say or to do in a circumstance unexpected by other people; it is reflection, it is meditation." - Napoleon I

GeneralRe: SQLite Thread Safety Pin
Richard Andrew x6410-Nov-23 16:33
professionalRichard Andrew x6410-Nov-23 16:33 
GeneralRe: SQLite Thread Safety Pin
Gerry Schmitz13-Nov-23 12:14
mveGerry Schmitz13-Nov-23 12:14 
AnswerRe: SQLite Thread Safety Pin
Jörgen Andersson12-Nov-23 22:16
professionalJörgen Andersson12-Nov-23 22:16 
QuestionSQLite syntax error that I can't figure out - SOLVED Pin
Richard Andrew x644-Nov-23 15:09
professionalRichard Andrew x644-Nov-23 15:09 
AnswerRe: SQLite syntax error that I can't figure out Pin
k50544-Nov-23 18:22
mvek50544-Nov-23 18:22 
GeneralRe: SQLite syntax error that I can't figure out Pin
Richard Andrew x645-Nov-23 2:57
professionalRichard Andrew x645-Nov-23 2:57 
Questionplease Pin
daw htikehtike21-Oct-23 20:17
daw htikehtike21-Oct-23 20:17 
AnswerRe: please Pin
Richard MacCutchan21-Oct-23 22:14
mveRichard MacCutchan21-Oct-23 22:14 
AnswerRe: please Pin
jschell23-Oct-23 6:25
jschell23-Oct-23 6:25 
AnswerRe: please Pin
Gerry Schmitz24-Oct-23 8:15
mveGerry Schmitz24-Oct-23 8:15 
AnswerRe: please Pin
CHill6030-Oct-23 0:44
mveCHill6030-Oct-23 0:44 
QuestionGetting Last Record and First Record from a Record Set (SQL server DB) Pin
Member 1184335621-Sep-23 9:07
Member 1184335621-Sep-23 9:07 
AnswerRe: Getting Last Record and First Record from a Record Set (SQL server DB) Pin
Richard Andrew x6421-Sep-23 9:58
professionalRichard Andrew x6421-Sep-23 9:58 
GeneralRe: Getting Last Record and First Record from a Record Set (SQL server DB) Pin
Member 1184335621-Sep-23 10:18
Member 1184335621-Sep-23 10:18 
GeneralRe: Getting Last Record and First Record from a Record Set (SQL server DB) Pin
Gerry Schmitz21-Sep-23 15:02
mveGerry Schmitz21-Sep-23 15:02 
Questionprior action plan to prevent sql database corruption Pin
Kar_Malay1-Sep-23 21:01
Kar_Malay1-Sep-23 21:01 
AnswerRe: prior action plan to prevent sql database corruption Pin
Richard Andrew x642-Sep-23 3:38
professionalRichard Andrew x642-Sep-23 3:38 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.