For example, if I wanted to log the temperature at a specific location every 30 minutes, do an aggregation to get the mean, low, and high at the end of the day, and don't care about the original data afterwards, what should I be using? Is there a name for this category of technology? submitted by /u/livingdeadghost [visit reddit] [comments ..read more

So I see that database courses are pretty common in undergrad curriculum, as opposed to say something like front-end development. I wonder if this means it's worth my time to audit a formal database class to learn the theory, or if it's more time efficient to just look at some SQL tutorials and work on a project? submitted by /u/pouyank [visit reddit] [comments ..read more

Hi, Currently I'm building a cross platform offline first desktop app. In future it might also give users an option to sync their data to cloud. When I searched for my use case I came to know about PouchDB which can be used to build offline first apps which can also be used with CouchDB in the cloud to sync the user data. Thus giving the users an option to have cloud backup. Although I have also came across SQLite during my search but didn't explore it much. After knowing about PouchDB. Any advice or opinions are welcome. submitted by /u/i-sage [visit reddit] [comments ..read more

databases used by multi billion dollar companies? submitted by /u/savant78 [visit reddit] [comments ..read more

I am making a small YouTube alternatives but I realized that the 100GB my webhost gives me is not a lot, I cant upgrade my plan because the max is 200GB without getting a plan that is hard to use. I need something that can go up to 10TB submitted by /u/Mrcool654321 [visit reddit] [comments ..read more

I'm managing a product feed for a manufacturing company and I'm finding that transferring data from one spreadsheet to another using lookup functions etc becomes problematic and the data never transfers properly and theres a lot of unnecessary cleanup involved. Does anyone have some tips or tricks as to how i should store and manage this data in a more efficient manner? submitted by /u/Elegant-Message-4582 [visit reddit] [comments ..read more

Hello ?, I’m looking to design a database for storing stock data in preparation for a prediction project. My issue is trying to decide which type of database to use because I want it to be able to show the already stored data even when I’m offline. Then synchronize later when I’m back online. I was looking at SQLite or InfluxDB but I’m really not sure? submitted by /u/Iseeall- [visit reddit] [comments ..read more

Hi. I’m looking for some feedback to see if the following is a good idea or not. Our product uses MySQL for the database. The database design policy we have always had was to not allow null columns unless absolutely necessary. This means that in 18 years, we have rarely needed them. However, one of my colleagues wants to introduce them for the majority of columns in new tables and new columns in existing tables as apparently, it will help find bugs in the front end JavaScript and backend PHP code. I personally don’t like the idea as we shouldn’t have to permanantly carry the additional baggag ..read more

Hello, I am new to databases, I would like to be able to add a sql file to a field of an Oracle 19c database table: I have done it this way but it gave me an error, I would like to know if it is the ideal way or if there are other ways: [oracle@baseoracle ~]$ ls Desktop Documents Downloads Music Pictures prueba.sql Public scripts Templates Videos SQL> CREATE TABLE Archivos ( ID NUMBER PRIMARY KEY, Nombre VARCHAR2(100), Contenido BLOB ); SQL> INSERT INTO Archivos (ID, Nombre, Contenido) VALUES (2, 'prueba.sql', EMPTY_BLOB()); 1 row created. SQL*Plus: Release 19.0.0.0.0 - Production on T ..read more

Hi all , I made mistake, without taking the DB dump, I've run the import comment in DB (PSQL) How can I retrieve the previous database that exists before importing? NOTE : I don't have backup db and I'm not using git. Kinldy comment the command which I wanna run in the DB. submitted by /u/_user_available_ [visit reddit] [comments ..read more