TTC
Theo's Typesafe Cult•2y ago
tropic

Can I use PostgreSQL as a timeseries database

Hi, I am doing a project to possibly use as my final major project at UNI...I know there are database hosting sites out there specifically for this but I am a tinkerer and was wondering if it a good idea to use PostgreSQL to store time series data. I am away that for a small scale project it doesn't matter but If I were to offer this as a full service would it end up biting me in the ass in the future.
5 Replies
tropic
tropic•2y ago
The whole point of me exploring this option is just for knowledge
Unknown User
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
cje
cje•2y ago
I agree that if this is the main focus on your project there are better options that being said we have this implemented in MariaDB at work with >10M rows and with a bit of indexing performance is not a problem 1-2 more orders of magnitude and SQL will probably not be great anymore
Unknown User
Unknown User•2y ago
Message Not Public
Sign In & Join Server To View
tropic
tropic•2y ago
I can self host that right Yes i can great I would only reach that level if i turn it into a service and then some how get all the MC community on it it is an analytics software for Minecraft, and for my project there is an option to make a database that collects data that you then have to run analysis though....I'm only going to be taking the performance and ping of all players but just wanted to use the opportunity to try out time series data Thanks for your input guys really appreciate it t3ggLove
Want results from more Discord servers?
Add your server
More Posts
How do you consume TRPC Next backend on other platform?i.e. Standalone mobile app.What to use to manage state in T3 stack appI want to implement a cart function for my app and was wondering what state management library to usMocked unit tests or Integration testsWhen running tests in the frontend that involves a server side call, do you prefer to mock the serveuseEffect deps for run on mountgiven an effect you want to run on mount like: ``` const publish = () => {…} useEffect(() => { puhow to get vite-plugin-relay to workhello. I'm trying to use this plugin as a last-mile build solution for the relay parts that need to How to add custom fonts in T3 appis there a definitive way of doing this I've tried many ways but none of them work. I want to use poHow to increase 1mb upload limitCurrently I have to call a mutation with trpc which passes an array with 1000+ elements using the t3RTK Query (with no redux) or React Query?I'm a noob, obviously, but a bunch of my friend called me out for making api requests in useEffect aSeperate or external back-endIs it good having a seperate back-end using e.g. Django and communicating with api, or is it best prexport default or...Okay so this is pretty subtle but confusing. I've once Heard that for example ```export default func