• 21 Posts
  • 1.03K Comments
Joined 2 years ago
cake
Cake day: June 20th, 2023

help-circle
  • You really have to see what the db is doing to understand where the bottlenecks are, i.e. find the query plans. It’s ok if it’s just single selects. Look for stuff like table scans that shouldn’t happen. How many queries per second are there? Remember that SSD’s have been a common thing for maybe 10 years. Before that it was HDD’s everywhere, and people still ran systems with very high throughput. They had much less ram then than now too.










  • Um the idea of a pendulum in an old fashioned clock is that it is actually the clock’s frequency reference. It’s purely mechanical, no electricity or radios. The length of the pendulum determines the frequency (usually 1 hz). You can slide the weight up and down a little bit to adjust the speed. The spring unwinding gives the pendulum a little kick on every swing so the clock doesn’t stop. You wind up the spring every so often so it doesn’t unwind completely, and the swinging pendulum advances a little ratchet that moves the hands a little on every swing. If you lived in a town in the pre-electricity era, the local church would ring its church bells at noon, 3pm, etc. and you would use that to set or adjust your clock as needed. The church clock itself was directly or indirectly set using solar noon (as observed with a transit telescope or dipleidoscope) as a reference. Fancier pendulum clocks had various sorts of thermal compensation and could be very accurate. It was a highly developed technology that is now mostly forgotten.

    Connecting wifi to this would be at best purely decorative. I guess it would be a cute hack but meh. You could look on hackaday.com which is full of projects like that. I’ve mostly found them kind of pointless, but that’s just me being a grouch.



  • Java isn’t exactly hard, and it’s not particularly fundamental. It’s just bureaucratic, and Python will be both more enjoyable and more useful. Java was trendy in the 1990s and lingers on because so much Java code is still around. If your goal is to use a serious type system (Lisp and Python don’t have that), Haskell will be far more enlightening than Java. If you want to use the JVM for some reason, Clojure (a Lisp dialect that run in it) might interest you.

    For low level fundamentals, you want assembly language! That gives you almost no assistance and you have to do EVERYTHING yourself, organizing the program in your own head. For old fashioned imperative programming with lots of organizational assistance, try Ada.

    You will probably have to learn C at some point, but save it for later when it will be easier for you to spot the weaknesses.