Click here to Skip to main content
14,774,665 members
Home » Discussions » Database
   

Database

 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Eddy Vluggen26-Jan-21 13:31
professionalEddy Vluggen26-Jan-21 13:31 
QuestionStoring Entity states in DB Pin
kabuto1787-Dec-20 17:31
Memberkabuto1787-Dec-20 17:31 
AnswerRe: Storing Entity states in DB Pin
Richard Deeming7-Dec-20 23:36
mveRichard Deeming7-Dec-20 23:36 
GeneralRe: Storing Entity states in DB Pin
Mycroft Holmes8-Dec-20 11:56
professionalMycroft Holmes8-Dec-20 11:56 
GeneralRe: Storing Entity states in DB Pin
kabuto1789-Dec-20 14:35
Memberkabuto1789-Dec-20 14:35 
QuestionResetting Value of Each User At Once (PHP MYSQLI) Pin
nateola444-Dec-20 23:14
Membernateola444-Dec-20 23:14 
QuestionRe: Resetting Value of Each User At Once (PHP MYSQLI) Pin
Richard MacCutchan5-Dec-20 0:05
mveRichard MacCutchan5-Dec-20 0:05 
QuestionThe Best Free Database for real-time data storing and querying Pin
Member 1332584625-Oct-20 21:04
MemberMember 1332584625-Oct-20 21:04 
I need a real-time database for inserting at least 500fields per second. (I have been selected TimeScaleDB (Postgresql Extension) for my purpose, currently). So, the matrix of the table will be 500(Fields)x86400(Rows).

This means that for a 500 double-precision field it will be around 500*8bytes=4000bytes which for 86400rows it will be 345,600,000bytes (345.6M).

I know a software which it is recording the same structure of data and the final daily volume of its database is only 84M~85M. Its Extension is *.tag so, i think it is a DataFlex database. It is not a free database and i also never used it.

Question:

1- Which free database is the best to use for real-time data storing and querying (at the moment of storing) based on your experience or knowledge?

2- Is there any database to have such a volume or even less for this size of data?

Thank you for your Help.

AnswerRe: The Best Free Database for real-time data storing and querying Pin
Victor Nijegorodov25-Oct-20 22:39
MemberVictor Nijegorodov25-Oct-20 22:39 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584627-Oct-20 23:17
MemberMember 1332584627-Oct-20 23:17 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Richard MacCutchan28-Oct-20 0:09
mveRichard MacCutchan28-Oct-20 0:09 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584628-Oct-20 1:26
MemberMember 1332584628-Oct-20 1:26 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Jörgen Andersson28-Oct-20 3:15
professionalJörgen Andersson28-Oct-20 3:15 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584629-Oct-20 19:47
MemberMember 1332584629-Oct-20 19:47 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Mycroft Holmes28-Oct-20 13:07
professionalMycroft Holmes28-Oct-20 13:07 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584629-Oct-20 19:56
MemberMember 1332584629-Oct-20 19:56 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Gerry Schmitz30-Oct-20 9:40
mveGerry Schmitz30-Oct-20 9:40 
AnswerRe: The Best Free Database for real-time data storing and querying Pin
Eddy Vluggen26-Jan-21 13:36
professionalEddy Vluggen26-Jan-21 13:36 
QuestionDatabase ADO exception on adding new record Pin
Peter Mortier16-Oct-20 5:21
MemberPeter Mortier16-Oct-20 5:21 
GeneralRe: Database ADO exception on adding new record Pin
Richard MacCutchan16-Oct-20 5:53
mveRichard MacCutchan16-Oct-20 5:53 
AnswerRe: Database ADO exception on adding new record Pin
CHill6016-Oct-20 6:18
mveCHill6016-Oct-20 6:18 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 2:58
MemberPeter Mortier19-Oct-20 2:58 
AnswerRe: Database ADO exception on adding new record Pin
Peter Mortier19-Oct-20 3:00
MemberPeter Mortier19-Oct-20 3:00 
GeneralRe: Database ADO exception on adding new record Pin
Victor Nijegorodov19-Oct-20 8:07
MemberVictor Nijegorodov19-Oct-20 8:07 
GeneralRe: Database ADO exception on adding new record Pin
Peter Mortier20-Oct-20 9:40
MemberPeter Mortier20-Oct-20 9:40 

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.