bonifartius 𒂼𒄄 @bonifartius@social.cleverlibre.org

A glimmer of light I found today on the usually dark and depraved realm that is #Reddit

humans :wow :amaze: pretty !
The sun: SHINE !!

Me

I have an unopened soft drink can sitting in a fairly cold part of my home, and at night it's now cold enough to reduce the pressure of the carbon dioxide inside the can to almost exactly atmospheric pressure. Each time the heat cycled on or off, it caused a metallic ping as the slightly domed lid inverted to equalize the pressure.

Wasn't until this morning that I figured out where that noise was coming from.

Top 9 features a database IDE should have for serious development of procedures/functions:

Knows about the SQL dialect I'm currently developing with (i.e. Postgres, MySQL etc.)
Introspects the schema including views, procedures etc.
Can do suggestions while I type, not only on tables and table columns, but also on parameters, variables and temporary tables defined inside a procedure
Can spot unused variables and references to non-existing tables/columns
Shows table and column definitions in the suggest box and on hover
Does not drop the procedure before it is re-created, until it can prove that it will compile. That could be accomplished by creating the procedure first under a temporary name
Shows dependencies between tables/columns and procedures, even if that is not natively supported by the database engine (again, by introspection)
Lets me quickly jump between different database objects without filling out a "search form"
Provides context-sensitive documentation of built-in database functions

While all of this is fairly standard for any programming language, the only DB IDE that can do all of this right now (at least for MySQL and Postgres) with exception of (6) is JetBrains DataGrip.

Other rather expensive tools only provide a small subset of these features. Tools I evaluated:

Navicat (most expensive and highly unstable)
DBeaver
TablePlus
Querious (macOS only)
DevArt's dbForge (Windows only, but the only tool that features a step debugger (!) for Stored Procedures)
MySQL Workbench
Pgadmin
DBVisualizer
Database Client extension in VSCode from Weijan Chen
Azure Data Studio

It seems that Jetbrains has literally zero competitors in this area - so they a bear hug from me.

#sql #database #mysql #postgresql

there is a protocol built on top of UDP that makes it a little better for reliability, does anyone remember what the name of that is so I can search foir it?

Lmao Jinping

Do you have any questions on the Medley Interlisp language, environment, tools, history, or project? Ask and I'll try to answer here.

I look forward to your questions as they'll provide valuable feedback on the system and help flesh out the FAQs on the project site.

https://interlisp.org

#interlisp #lisp #retrocomputing

1. Push really hard that atmospheric C02 reduction is the most important political issues in the world.
2. People realize that trees are a simple cost-effective way to absorb C02.
3. People start initiatives to plant trees
4. Suprised pikachu face
Maybe the problem was the oversimplification in the first place.
https://archive.is/8gMt4

@jeffcliff @anonymous @Data @xue @1goodtern @DavidB @greyknight33 @Coyote @waifu ok let's make this simple enough for a retarded normie sheep. what makes the covid virus so bad is the spike protein (gain of function). The injections cause the body to produce the very gain of function component that makes it so bad. Can you seriously not put 2 + 2 together and realize you have been lied to?

I understand licensing vehicles for roads they've built & manage, & can be persuaded re lakes & rivers. But they own and manage wildlife? And nearly all of commerce? Appraisers didn't cause the S&L crisis, and accountants didn't cause the tech bubble or Enron. We were banks & Wall St's fall guys. Doctors & dentists& cosmetologists, lawyers, etc. How many were fall guys from the free market since 1913? You need a license for virtually every business, profession & occupation now. Think about that.

Blocking internet access via DNS

> Mercurial's CLI felt like an improved extension of SVN's, Darcs felt like a drastically different take with plenty for it, Git's felt like one of those ransom letters cut out of newspapers, full of jangly bits which make little sense, and concepts which worked fine altered for no perceivable reason.

lmao

bunnys

everything that slightly inconveniences me is a monopoly, a chlidren's guide to anti-trust

yea @xarvos, nixpkgs has tons of proprietary software

for this reason and the way go programs are packaged i’m transitioning to guix, and fyi there’s a guix service on nixos and vice versa