Click here to Skip to main content
14,742,220 members
Home » Discussions » Database
   

Database

 
PinnedHOW TO ANSWER A QUESTION PinPopular
Chris Maunder16-Jul-09 4:10
cofounderChris Maunder16-Jul-09 4:10 
PinnedHow to get an answer to your question PinPopular
Chris Maunder10-Nov-05 17:30
cofounderChris Maunder10-Nov-05 17:30 
QuestionFirebird : SQL to Get record today only Pin
kerek221-Jan-21 16:12
Memberkerek221-Jan-21 16:12 
AnswerRe: Firebird : SQL to Get record today only Pin
Richard MacCutchan21-Jan-21 23:05
mveRichard MacCutchan21-Jan-21 23:05 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 14:03
Memberkerek224-Jan-21 14:03 
AnswerRe: Firebird : SQL to Get record today only Pin
Mycroft Holmes22-Jan-21 12:00
professionalMycroft Holmes22-Jan-21 12:00 
AnswerRe: Firebird : SQL to Get record today only Pin
DerekT-P23-Jan-21 9:18
professionalDerekT-P23-Jan-21 9:18 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 14:09
Memberkerek224-Jan-21 14:09 
QuestionSQL Server: Retry update if fail Pin
Mou_kol8-Jan-21 5:22
MemberMou_kol8-Jan-21 5:22 
AnswerRe: SQL Server: Retry update if fail Pin
Richard Deeming8-Jan-21 5:49
mveRichard Deeming8-Jan-21 5:49 
QuestionSQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 5:19
MemberMou_kol8-Jan-21 5:19 
AnswerRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Richard Deeming8-Jan-21 5:51
mveRichard Deeming8-Jan-21 5:51 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 6:01
MemberMou_kol8-Jan-21 6:01 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Eddy Vluggen1 hr 50mins ago
professionalEddy Vluggen1 hr 50mins ago 
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 

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.