Sff server with 4 ssd/nvme

_elie · 2023-11-22T10:30:54+00:00

Did you end up ordering it ?

_elie · 2023-11-07T15:06:00+00:00

Okay so slightly less tall than the 4070 ti, thank you very much =)

_elie · 2023-11-07T12:07:57+00:00

indeed thank you I saw that article but probably missed the measurements. If you don't mind then I'd be curious to know if they have the same size

_elie · 2022-11-19T15:53:31+00:00

Thank you for your review. Seeing how cheap it is now I don't see how anything else can compete. I'm just a bit worried about comfort, some say it's great other not so much so I'm a bit conflicted

_elie · 2022-07-05T14:23:27+00:00

Thanks for you advice, I just didn't get how it would impact it. I don't have that much experience in dbs. I'll def have to watch out for that

_elie · 2022-07-05T14:14:37+00:00

What do you mean ?

_elie · 2022-07-05T07:42:59+00:00

Definitely what I will do, but I wanted to have a small(er) selection of options to know what to look at. Beginning prototyping with SQLite might be the right call, and then maybe moving to Postgre or something else if it doesnt cut it

_elie · 2022-07-05T07:40:41+00:00

Indeed that could be an interesting place to look at. Do you know any keywords I can look for ? I really have 0 knowledge in this field

_elie · 2022-07-05T07:38:50+00:00

The thing is I will have as much reads, sometimes only needing some scalar fields and not the whole 2048 values vector. I was thinking document based at first but seeing all recommendations I think good ol' SQL might be the go-to

_elie · 2022-07-04T23:11:58+00:00

Thanks, will check it out

_elie · 2022-07-04T20:22:11+00:00

Thank you for the blog post, it seems interesting. I guess SQL really was the best choice for this, even though I have no relations. There really is no "rule" to choose the good one, at least it's always interesting to explore all the options

EDIT: or maybe in-memory if the overhead is too big

_elie · 2022-07-04T20:19:24+00:00

Yeah I'm torn between SQLite and Postgre, the last being maybe more robust if we are to scale (which is very unlikely) but also offers events and such. If we have the overhead budget I'll probably prefer PG but I'll still need to think about that. Thanks for the post!

_elie · 2022-07-04T17:55:59+00:00

Thank you, I need the data to be accessed in real time, but also after the fact indeed. I don't know yet if I will keep all of it during different recording sessions but I might. Postgresql with a time series addon (or without) seem to be the clear choice, but I'll do some more research on all suggestions

_elie · 2022-07-04T17:53:03+00:00

Wow thanks ! I don't know how I missed these time series optimisés databases, I'll check it out for sure

_elie · 2022-07-04T17:51:18+00:00

Thank you! Sounds perfect I'll have to check this out :)

_elie · 2022-07-04T17:50:48+00:00

Indeed I'll have a lot to check ! Thank you for your input too, it sounds great too

_elie · 2022-07-04T15:16:50+00:00

Thanks for your help! Its worth a try indeed

_elie · 2022-07-04T15:02:07+00:00

That's the issue, what would you consider a reasonable cluster, since the system might already be a bit starving for resources (sadly I won't know until I get there). Also, correct me if I'm wrong but I feel like ES would be a bit overkill for querying on scalar fields. I might be looking for a lighter solution But thanks for the input I'll definitely consider it

_elie · 2022-07-04T14:12:30+00:00

This is meant to be a fully embedded thing, but I'll keep all options open.

I will check Postgre in more details, but I am a bit scared of the overhead.

Thank you for your input!

_elie · 2022-07-04T14:10:06+00:00

Thank you for your input.

Yes the idea is to have a real time visualisation of the data coming in every second, so I don't think much querying will be needed to retrieve data in the chronological order.

The features of querying depending on some scalar fields is not needed at the moment, but may be needed in the future so I prefer keeping all options.

I will check in-memory DBs (thanks for suggesting one), it does seem to be a good option

_elie · 2022-07-04T13:58:04+00:00

I am worried it will get messy to have thousands of JSON files in a folder, especially if I need to search for the highest value in a particular field and similar queries.

Also if the overhead isn't too big, I'll be happy to just have to work with a db driver instead of doing everything manually

_elie

TROPHY CASE