Gregory's Server
@blacklight @rrwo @szescstopni @Threadbane NoSQL is even older than that. As for SQL sadly I have used most of them. SQL has its place, like anything. The key difference between the way say some webshit like facebook is built and Voyager comes down to the way the project is managed. There is no move fast and break things with a nuclear power plant. It's the old school SSADM with endless reams of docs, specs, ERDs and dusty old process Very high detail, labor intense, expensive software cycle.
|
10 comments
 @nf3xn @blacklight @rrwo @szescstopni @Threadbane Ha! I remember one of the last times I used a SQL database for a trivial purpose .. garage temperature recording. I guess it cracked me up at that point how ridiculous it was to have a full unix(ish) stack and SQL to run a thermometer. As an added bonus this pi zero and the one in the kitchen communicated, doing data replication for fault tolerance. It's still funny to me.  @John @nf3xn @blacklight @rrwo @szescstopni @Threadbane ah yes, for my first temperature measurement I also used a Zero W with a Postgres db and a pythons script writing to it every minute. Now I use an RPi Pico sending data by MQTT to a server which ingests those messages to InfluxDb, which is read by Grafana. @stfn @nf3xn @blacklight @rrwo @szescstopni @Threadbane That sounds cool and much more modern. My boards answered my questions, which were basically about how the temperature cycle looked in my house with no heat or cooling (not present anyway) running. Before running the test I had not really internalized that the coldest part of the night is not midnight ;-)  @blacklight @John @stfn @nf3xn @rrwo @szescstopni @Threadbane sqlite has triggers. @John this is a very interesting project: do you have some links or details about hardware and software that you have used to achieve it? @seblm I think my method was a little idiosyncratic. If I remember correctly I used a DHT11 temperature sensor, and wrote c code to take a reading and insert it in the database. I just set that c code up as a cron job. I used shell scripts and cron jobs to do my data replication, database dumps and rsyncs if I remember correctly. There are lots of ways to skin the cat, and if you search for raspberry pi DHT11 (or DHT22) there will be lots of examples.  @John @nf3xn @blacklight @rrwo @szescstopni @Threadbane @nf3xn @blacklight @rrwo @szescstopni Ouch, yeah. I came in at the start of the floppy era. Before that we actually shipped clinical instruments with ROM boards only, and updates were shipping a new board. Part of our department was still doing that. There was this big consciousness that, even with floppies, you never knew they would reach their destination, and out of date software might live for many many years. |
@nf3xn @blacklight @rrwo @szescstopni @Threadbane I agree. In the old days I worked coding assembly language for medical instruments that would be in the field for decades. Certainly compared to today a lot of care was put into 64k. But as you say that's more about problem domain than technology
(I have also spun up MySQL instances for really trivial things, like organizing files at home.)