Gizmodo: The First Footage From Aquaman 2 Looks Wild https://gizmodo.com/aquaman-2-trailer-release-date-jason-momoa-james-wan-1850823934 #davidlesliejohnsonmcgoldrick #aquamaninothermedia #yahyaabdulmateen #patrickwilson #dolphlundgren #thomassibbett #nicolekidman #randallpark #nuidisvulko #arthurcurry #stephenshin #jasonmomoa #warnerbros #blackmanta #thetrench #atlantis #jameswan #aquaman #johnson #nereus #mera #orm

So after scratching my head for hours trying to understand why #Prisma #ORM wasn't returning any records when I was filtering by date, it turns it doesn't do a good job of handling #SQLite dates. 😒 In the end, I had to resort to using a raw query https://github.com/prisma/prisma/discussions/8956

So after scratching my head for hours trying to understand why #Prisma #ORM wasn't returning all records when I was filtering by date, it turns it doesn't do a good job of handling #SQLite dates. 😒 In the end, I had to resort to using a raw query https://github.com/prisma/prisma/discussions/8956

#Python’s #SQLAlchemy: 3 powerful features you need to know

https://itnext.io/pythons-sqlalchemy-3-powerful-features-you-need-to-know-433a8af565ec

#ORM #database

Cos'è Laravel, come funziona e architettura di base per la creazione di applicazioni WEB
Laravel è un framework Web basato su PHP per la creazione di applicazioni Web di fascia alta, ...
#framework #laravel #mvc #orm #php

https://bloginnovazione.it/laravel-php/35873/

Python: Just Write SQL
https://joaodlf.com/python-just-write-sql
#ycombinator #python #sql #postgresql #orm #raw_sql #sqlalchemy #django_orm

J'ai l'impression que je partage la même préférence que Riss Harris (auteur de #Svelte) : #RawSQL plutôt que #ORM

https://twitter.com/Rich_Harris/status/1655265972012318720?s=20

A bit of a programmer rant...

People wonder why I like ORMs even when they're unnecessary. Firstly, I've never liked SQL. I think that writing queries to a RDBMS is something that a computer should do, akin to compilation. In the few times when extreme optimization is warranted, low level code can be generated to suit that specific case. In other times, ORMs usually provide a more natural interface to data that increases readability and code flow.

#programming #rant #sql #databases #orm

1/2

@psFried @vwbusguy

I've been spoiled by #ORM and honestly I haven't even noticed differences between #Postgress and other databases.

A fun experiment I am in the mood to try is to take my entire #Redis implementation of my code running in #Docker and just replacing it with #IPFS.

I currently can't imagine any advantages, I mean, come on, it's Redis. But I just thought it would be a fun experiment to try. An IPFS implementation would allow for transaparency of user data, which is stored with decentralized storage similar to #gunDB.

Although the same propogation of network data with #gunDB wouldn't be the same and the native security and encryption of gunDB would be nice, I just want to mess around with the idea.

With Redis, relationships between sets are created with primary and secondary keys and referencing other records. But IPFS could give the same behavior as a standard #ORM and something like #SQL.

Also, I've wanted to benchmark IPFS for such usage before and because I know the Redis speeds now, 15k commands/s, this would be interesting to see even just in Docker and on my LAN network.

@lsmith

In memory #sqlite is also a good option. I like sqlite because there are great tools like #SQLAlchemy which allows you to have #ORM features, but if it is simple I would just go with the built-in libraries to improve performance.

I also like sqlite with #Docker, as I have the simplicity of a sqlite database, but I can easily share it with containers with mounts and persist the data during development and production.

#VScode also has greay extensions for viewing sqlite databases, making it a glorified csv with advanced query capabilities.

@orsinium

I prefer to use something more popular, that the support is better. The docs of #SQLAlchemy are a bit odd. I found myself getting stuck after the tutorial, like you said. It seems 2.0 documentation isn't the best with the new declarative style, but I found some other resources, and I am diving into code I found on #Github to see how others did it.

#Peewee is cool, but the names like that always turn me off. I need serious names for libraries I use, I don't know. But I can see that it had great influence from modern #JS #ORM styles, so it might be better for people coming from that.

Thanks for the info!

#Python

@setebos

I am aware of the limitations, but I am far below them. I want to project to be easily deployable by others and then the usage will also be low enough for it to suffice.

#Peewee feels a lot like the web-development #ORM that you get for #React and #JS, but I like #SQLAlchemy, the docs also seem good.

What is your favorite #Python #ORM for #SQL and #SQLite? I am currently looking for an ORM judt to sinplify my implementation.

I am considering going for SQLite because the writes and reads are low, and the total size will also be a few 100 records, but I want the strengths of SQL. Also, I am running it in #Docker, so it simplifies the deployment.

I am looking at #SQLAlchemy and also saw #Peewee on #Github.

This is the first time I am doing something like this. Normally, my data is simply printed to CSV files.

ICAO: 407D02
Flt: GICER #CEG-#ORM
First seen: 2023/07/15 12:27:56
Min Alt: 1175 ft MSL
Min Dist: 9.91 mi

#planefence #adsb #mendip
https://flightaware.com/live/modes/407d02/ident/GICER/redirect

@justindz @RethinkJeff Most people use #SQLAlchemy as #Python #ORM but it can be hard to grasp sometimes. There are many ways to do the same thing and the documentation is a mess. Still, I don't know other alternatives with as good support for async and typing. Plus, it's popularity means lots of tutorials.

If you still want to try alternatives, I listed some of them here:
https://t.me/itgram_channel/581

I might actually get something useful out of it. The same reflection on fields allows to make type-safe conditions, which is rare for Go ORMs. In the example below, type checker knows that the field `user.age` is int and requires the second argument also be an int. Finally, a place where generics do fit and help.

#golang #orm

Despite a failure to do anything good with generics, I found an interesting hack (with reflection and unsafe pointer comparison) when you can directly pass struct fields to be used in queries.

I wonder if that can be useful in practice. I like that you can press "go to references" on the field in IDE and find all queries that fetch the field.

#golang #orm

Would you folks be interested in a type-safe #golang #ORM that uses generics instead of code generation or reflection? I have a few ideas, but I'm not sure if Go really needs yet another ORM.

Discover the roller coaster ride of ORM in Java with its pros and cons in our latest blog post!
https://www.eliza-ng.me/post/ormsql/
#Java #ORM #LoveHateRelationship