Click here to Skip to main content
14,975,411 members
Home / Discussions / Database
   

Database

 
GeneralRe: need website to create database Pin
Gerry Schmitz6-Feb-21 9:31
mveGerry Schmitz6-Feb-21 9:31 
QuestionFirebird : SQL to Get record today only Pin
kerek221-Jan-21 15:12
Memberkerek221-Jan-21 15:12 
AnswerRe: Firebird : SQL to Get record today only Pin
Richard MacCutchan21-Jan-21 22:05
mveRichard MacCutchan21-Jan-21 22:05 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 13:03
Memberkerek224-Jan-21 13:03 
AnswerRe: Firebird : SQL to Get record today only Pin
Mycroft Holmes22-Jan-21 11:00
professionalMycroft Holmes22-Jan-21 11:00 
AnswerRe: Firebird : SQL to Get record today only Pin
DerekT-P23-Jan-21 8:18
professionalDerekT-P23-Jan-21 8:18 
GeneralRe: Firebird : SQL to Get record today only Pin
kerek224-Jan-21 13:09
Memberkerek224-Jan-21 13:09 
QuestionRe: Firebird : SQL to Get record today only Pin
David Crow12-Mar-21 6:40
MemberDavid Crow12-Mar-21 6:40 
QuestionSQL Server: Retry update if fail Pin
Mou_kol8-Jan-21 4:22
MemberMou_kol8-Jan-21 4:22 
AnswerRe: SQL Server: Retry update if fail Pin
Richard Deeming8-Jan-21 4:49
mveRichard Deeming8-Jan-21 4:49 
QuestionSQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 4:19
MemberMou_kol8-Jan-21 4:19 
AnswerRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Richard Deeming8-Jan-21 4:51
mveRichard Deeming8-Jan-21 4:51 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Mou_kol8-Jan-21 5:01
MemberMou_kol8-Jan-21 5:01 
GeneralRe: SQL Server Difference among ROWLOCK ,UPDLock AND xlock Pin
Eddy Vluggen26-Jan-21 12:31
professionalEddy Vluggen26-Jan-21 12:31 
QuestionStoring Entity states in DB Pin
kabuto1787-Dec-20 16:31
Memberkabuto1787-Dec-20 16:31 
AnswerRe: Storing Entity states in DB Pin
Richard Deeming7-Dec-20 22:36
mveRichard Deeming7-Dec-20 22:36 
GeneralRe: Storing Entity states in DB Pin
Mycroft Holmes8-Dec-20 10:56
professionalMycroft Holmes8-Dec-20 10:56 
GeneralRe: Storing Entity states in DB Pin
kabuto1789-Dec-20 13:35
Memberkabuto1789-Dec-20 13:35 
QuestionResetting Value of Each User At Once (PHP MYSQLI) Pin
nateola444-Dec-20 22:14
Membernateola444-Dec-20 22:14 
QuestionRe: Resetting Value of Each User At Once (PHP MYSQLI) Pin
Richard MacCutchan4-Dec-20 23:05
mveRichard MacCutchan4-Dec-20 23:05 
QuestionThe Best Free Database for real-time data storing and querying Pin
Member 1332584625-Oct-20 20:04
MemberMember 1332584625-Oct-20 20: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 21:39
MemberVictor Nijegorodov25-Oct-20 21:39 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584627-Oct-20 22:17
MemberMember 1332584627-Oct-20 22:17 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Richard MacCutchan27-Oct-20 23:09
mveRichard MacCutchan27-Oct-20 23:09 
GeneralRe: The Best Free Database for real-time data storing and querying Pin
Member 1332584628-Oct-20 0:26
MemberMember 1332584628-Oct-20 0: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.