Posts by ghard@mastodon.social
(DIR) Post #APCoNrSTrx4N0XsIyG by ghard@mastodon.social
2022-11-02T20:50:19Z
0 likes, 1 repeats
@Gargron Also most DB engines really need a sh*t-ton of RAM. If the DB has to go to disk - even SSD - you’re in a world of pain. Biggest challenge is to balance RAM / CPU. Sometimes need to tweak OS VM paging parms as well. A good DB does its own paging, as these workloads differ greatly from regular processes.
(DIR) Post #APCoNsymDMUtizzbwu by ghard@mastodon.social
2022-11-02T20:54:57Z
0 likes, 0 repeats
@Gargron Most DB setups using shared-nothing clustering/sharding aren’t to increase CPU counts, but rather to increase available RAM.
(DIR) Post #AQv4BryOiGUZ3UJ6wq by ghard@mastodon.social
2022-12-24T03:42:49Z
0 likes, 0 repeats
@veer66 All systems I use have caps lock mapped as ctrl. Couldn’t live without.
(DIR) Post #ATxDpvs7APKzyFBIci by ghard@mastodon.social
2023-03-24T22:16:38Z
0 likes, 0 repeats
@stux A subconscious rickroll is just as good as - or maybe even better than a full-frontal one.
(DIR) Post #AUROmgbymZZAKXS1gW by ghard@mastodon.social
2023-04-08T11:40:41Z
0 likes, 0 repeats
@galdor Those days we were in a 10 developer shop with a 2-process license for Sun’s C compiler - NetHack was a perfect solution for waiting times 😅
(DIR) Post #AURY6v2RkiBESBYNAO by ghard@mastodon.social
2023-04-08T13:05:24Z
0 likes, 0 repeats
@adyxax @galdor Archaeologist is my favourite role. Pick axe and touchstone come in handy for lots of things.
(DIR) Post #AVeBSSjvXONCU3xvCS by ghard@mastodon.social
2023-05-14T13:34:42Z
0 likes, 0 repeats
@galdor Yep! Pretty much the story of my life. Learned to not push too hard against the brick walls - let it simmer and wait for the right moment for an answer to present itself. Making use of a programming language like #lisp that facilitates exploratory, dynamic (meta)programming is essential.
(DIR) Post #AWIPEhYOEn23BrefSa by ghard@mastodon.social
2023-06-02T23:17:32Z
0 likes, 0 repeats
@galdor @louis YMMV but I’ve found LOOP to be just the concise DSL needed to process some aggregates iteratively at one go. Arguably ITERATE may be ”lispier” - whatever that means - but I choose to use the standard way since it’s minus another dependency.
(DIR) Post #AWIPlwpgS4TY8Kb53Q by ghard@mastodon.social
2023-06-02T23:23:31Z
0 likes, 0 repeats
@louis @galdor a very common set of use cases perhaps. TCO is not mandated by the standard, AFAIK, so iteration constructs that are concisely expressed should be a good thing. And to show off the malleability of the language and troll the paren haters?
(DIR) Post #AXWOsdUseMyTFmPMTA by ghard@mastodon.social
2023-05-03T16:01:11Z
1 likes, 0 repeats
@Kye "That is not dead which can eternal lie, And with strange aeons even death may die."
(DIR) Post #AZt0FTHQrFAOqavT6W by ghard@mastodon.social
2023-09-18T08:38:10Z
0 likes, 0 repeats
@galdor @svetlyak40wt Around a few million users of what is a rather typical OLTP workload, I'd not worry about the actual app workloads as much as about the absolutely bonkers ad-hoc BI queries - and latencies required - for ad delivery for monetisation purposes.
(DIR) Post #AaIaH9jnDhVmE07DY8 by ghard@mastodon.social
2023-09-30T16:49:39Z
0 likes, 0 repeats
@louis Once bitten - twice shy. So I’m holding the upgrade until one or two bugfix releases usually.
(DIR) Post #Ab5fEf3KYaVDvnvIJs by ghard@mastodon.social
2023-10-24T08:52:35Z
1 likes, 0 repeats
@hayley @strypey @screwtape @ellenor2000 @lispi314 I remember seeing a youtube video testing that not so long ago. Several TB per trip it was, but don’t remember the final calculation. Their system lacked ACK/NAK so extra RTT would have to be added if reliability is a factor. Retry times due to random encounters with a neighbouring peregrin falcon, etc.
(DIR) Post #Ab5fEhRreLJdMTPuq0 by ghard@mastodon.social
2023-10-24T08:55:31Z
0 likes, 0 repeats
@hayley @strypey @screwtape @ellenor2000 @lispi314 Also… this: https://www.rfc-editor.org/rfc/rfc2549
(DIR) Post #Ac6zuvLOJ2IHVz5p0i by ghard@mastodon.social
2023-11-23T22:24:32Z
0 likes, 0 repeats
@louis Ha! You’ve discovered my secret sauce 😀 Data should always be handled where it resides. Stored procedures are essential and the SP API can be further secured by granting individual procedures only to clients that should have access. Though my DB engine choice - for historical reasons - is different. Common #Lisp + plain ODBC makes a great front-end.
(DIR) Post #Ac8aCFz8bhuxxlCyo4 by ghard@mastodon.social
2023-11-24T16:45:50Z
0 likes, 0 repeats
@louis I used to be a developer at Openlink Software so their Virtuoso VRDBMS is what I know best. The DB engine borrowed a lot of ideas from SQL Server, and the stored procedure language is more of a C-like syntax, though the head developer is an old lisper - they made a Common Lisp compiler for Nokia when they had a 80186-based microcomputer. Virtuoso can mix and match SQL and SPARQL queries as subqueries, etc. Deployment is 3 files: exe, db and a config file.
(DIR) Post #AlzHQy65me70KdGH3I by ghard@mastodon.social
2024-09-14T07:44:13Z
0 likes, 1 repeats
@ErikUden This is a pogrom - no less.
(DIR) Post #ArI9YYJTwPQGw51pwW by ghard@mastodon.social
2025-02-19T12:30:15Z
0 likes, 0 repeats
@emmiehine there’s a Judge Dredd story I remember that touches this.
(DIR) Post #ArI9YdJfL9XaS69YQK by ghard@mastodon.social
2025-02-19T12:40:54Z
0 likes, 0 repeats
@emmiehine Yeah guard-o-ped in ”Are you afraid of getting mugged?” ”Bring me the fridge Hermie - I see another one walking down there.”
(DIR) Post #AtDNuOUMbawxfw6ct6 by ghard@mastodon.social
2025-04-18T12:07:23Z
0 likes, 0 repeats
@stux an emotional support vehicle.