@derflocki@phpc.social
@derflocki@phpc.social avatar

derflocki

@derflocki@phpc.social

I build backends and frontends, mainly with PHP/Oracle and HTML/Angular/. Also: 🚵🏐🤿🧑‍💻🌏🕹️ and FF7

This profile is from a federated server and may be incomplete. Browse more on the original instance.

Crell, to php
@Crell@phpc.social avatar

Silly me for thinking I couldn't find an ORM I dislike more than the ones I've used in . Then I found Spring Boot / JPA...

This is a whole new level of asinine...

derflocki,
@derflocki@phpc.social avatar

@Crell And I thought I'm the only one. Running anything that is a little more complex than SELECT * FROM TABLE and maybe some joins is such a pain. SQL is so powerful, versatile and fast, but I feel that most of this is inaccessible due to ORMs that sit between you and the data.

Have you ever worked with JOOQ? It seems to get a lot right in that regard.

nyamsprod, to php
@nyamsprod@phpc.social avatar

Coming soon in the next minor release of League\Csv 😍
still ironing the feature that you can already test on the master branch. give it a try
https://csv.thephpleague.com/9.0/reader/statement/#where-clauses

derflocki,
@derflocki@phpc.social avatar

@nyamsprod neat idea. I'm curious have you experimented with (does this even work in php) the csv support in sqlite? https://www.sqlite.org/csv.html

derflocki,
@derflocki@phpc.social avatar

@nyamsprod Thanks for the explanation!

simon, to random
@simon@simonwillison.net avatar

I'm quoted in this @arstechnica piece about that recent "AI generated" George Carlin special

I don't think it was written by AI

I found the whole thing grossly disrespectful, but I do slightly appreciate the meta-joke here that the AI generated text is fake and was actually written by humans

https://arstechnica.com/ai/2024/01/did-an-ai-write-that-hour-long-george-carlin-special-im-not-convinced/

derflocki,
@derflocki@phpc.social avatar

@ramsey @simon
My mental model of what an llm is that it's a "probability machine": given some input it generates the most probable output.

If you want to go deeper, I have found this article by Stephen Wolfram quite helpful: https://writings.stephenwolfram.com/2023/02/what-is-chatgpt-doing-and-why-does-it-work/

heiglandreas, to random
@heiglandreas@phpc.social avatar

Really ? I can use 2.537 different databases as datasource but the only plugin that allows me to use LDAP as datasource is 3rd party provided and 4 years old?

So back to Apache Directory Studio again... 😡

A well. Who needs a fast and reliable tree-structured NoSQL datastore anyhow 🤷

derflocki,
@derflocki@phpc.social avatar

@heiglandreas In case you didn't know: curl supports ldap queries 🤓

derflocki, to random
@derflocki@phpc.social avatar

@phanpy I guess that's not how closing toot details should work 🤣

Accidently closing toot details by selecting text in Firefox on Android

derflocki,
@derflocki@phpc.social avatar

@cheeaun @phanpy Hi! Yeah I can reproduce it. I'm in Firefox 119.1.1 on Android 14.

The key is to select text close to the right screen edge, this moves the Toot-Details popup slightly bottom right, and the "actions popup" of Firefox appears. Tapping and scrolling on the Toot-details starts sliding off the screen.

A toot gently sliding off screen

kboyd, to random
@kboyd@phpc.social avatar

Is there an equivalent to electron that uses gecko instead of chromium?

derflocki,
@derflocki@phpc.social avatar

@Crell @kboyd Tauri is based on Web Views, so it's essentially webkit/blink, but see here for more details https://tauri.app/v1/references/webview-versions
I had researched this a couple of years ago, and I hadn't found anything viable.

ramsey, to random
@ramsey@phpc.social avatar

Problem: I have two DB tables, and I’m trying to select from the first table for records that do not exist in the second table. Over time, as I process each record, I’ll write to the 2nd table, and then those records will be excluded on subsequent queries.

Pretty standard stuff. The queries are easy to write, and there are several ways to write them (e.g. left join where is null, where not in subquery, where not exists subquery).

1/2

derflocki,
@derflocki@phpc.social avatar

@ramsey
If the query can be transformed to "T1 minus T2" this could improve performance. If T1 is significantly smaller that T2, you could try T1 - (T1 inner join T2). If you have proper indices for the join clause this could perform better. With 5.7 you should be able to use partitioning. Essentially what @seldo suggested but in a single "logical table". If you have more questions feel free to contact me. Maybe I can help. Good luck

ramsey, to random
@ramsey@phpc.social avatar

When I start on new code, I often don’t have the full architecture in mind yet. That is, I can’t see it. I have to start writing out the code all as one big procedural blob before I start to see patterns emerge that I can then abstract into separate concerns.

derflocki,
@derflocki@phpc.social avatar

@ramsey same for me. This is why I struggle with TDD.

derflocki,
@derflocki@phpc.social avatar

@ramsey That's reasonable. Thanks!

  • All
  • Subscribed
  • Moderated
  • Favorites
  • •
  • provamag3
  • rosin
  • ngwrru68w68
  • Durango
  • DreamBathrooms
  • mdbf
  • magazineikmin
  • thenastyranch
  • Youngstown
  • khanakhh
  • slotface
  • everett
  • vwfavf
  • kavyap
  • megavids
  • osvaldo12
  • GTA5RPClips
  • ethstaker
  • tacticalgear
  • InstantRegret
  • cisconetworking
  • cubers
  • tester
  • anitta
  • modclub
  • Leos
  • normalnudes
  • JUstTest
  • All magazines
    •