attention eBook worms
humble bundle offers SQL and Databases by O'Reilly

attention eBook worms
humble bundle offers SQL and Databases by O'Reilly
Data Annotations Max Length Entity Framework in C# Tip #115 #learntocode #learncoding #codingbasics #softwaredeveloper #codinglife #coding #codingforbeginners #linq #datascience #visualstudio #databases #softwareengineer #sqlserver #vscode #csharp #dotnet #visualstudiocode #webdevelopment #computerscience #sql
#Postgres vs. #SQL Server: B-Tree Index Differences & the Benefit of Deduplication https://pganalyze.com/blog/postgresql-vs-sql-server-btree-index-deduplication
https://www.analyticsvidhya.com/blog/2021/06/join-the-dataframes-like-sql-tables-in-python-using-pandas/ - joining #data frames in #Python and #Pandas. Nice analogies to #SQL Nilabh.
Proud of myself: today I sped up one of my client's processes by 75 times.
It's an #SQL query on a database server that until late last year ran an outdated version of the DBMS. Solutions used were optimized for that version, but the newest version can do a couple things much, much faster. Attempts were tried, tested, and measured. Progress!
SQL Injection as a Feature
Link: https://idiallo.com/blog/sql-injection-as-a-feature
Discussion: https://news.ycombinator.com/item?id=44638304
#Development #Pitfalls
The hard truth about soft deletion · Fake deletions of database records cause real problems https://ilo.im/165eye
_____
#Programming #Coding #Maintenance #SoftDeletion #Database #SQL #Ruby #WebDev #Backend
Today's Poll...
What is a DML statement in SQL?
Announcing streamlined MLOps with Orbital on Databricks
Orbital translates #ScikitLearn #Python or #tidymodels #RStats to native #SQL for direct database model execution.
Edgar Ruiz's post uses #Databricks as an integrated environment.
Learn more: https://posit.co/blog/databricks-orbital-r-python-model-deployment/
https://queryquest.de ist mein Vorschlag als Alternative zum bekannten SQL Island: SQL spielerisch mit einer Inselflucht lernen ohne zu töten, machbare Lernkurve, Aufgaben überspringen, Tipps, für Lehrkräfte beobachtbarer Lernfortschritt.
Query Quest lässt sich leicht um eigene Datenbanken und Missionen erweitern. Schreib mir gern, wenn du Ideen hast.
Apply migration without data loss with Entity Framework in C# Tip #110 #visualstudiocode #databases #softwaredeveloper #codingbasics #codinglife #learncoding #codingforbeginners #dotnet #coding #linq #datascience #learntocode #visualstudio #softwareengineer #webdevelopment #computerscience #sqlserver #csharp #vscode #sql
EnsureDeleted in Entity Framework in C# Tip #108 #linq #codingforbeginners #codingbasics #sqlserver #webdevelopment #softwareengineer #visualstudiocode #databases #softwaredeveloper #computerscience #codinglife #sql #learncoding #csharp #dotnet #coding #datascience #learntocode #vscode #visualstudio
Fun fact: #SQL is over 50 years old now.
Do any of the litany of frameworks stay relevant for 50 weeks?
When I was on the bird site, I followed the #SQL hash tag to learn about Structured Query Language, databases, and the like.
I follow #SQL in the Fediverse too.
But here, the vast majority of posts are about frameworks, ORM's, and other tools folks can use so they don't have to learn (or understand) a 4G language that's likely a lot simpler than the other tech complexities they've mastered.
I don't know how we got here.
Ah yes, the thrilling saga of tripping over #foreign #keys while trying to keep your #database #integrity intact — because who doesn’t love a good faceplant into SQL?
Like a true heroic tale, this guide fills you in on how to transform your #Django #ORM into a minefield of foreign key #blunders, ensuring you achieve maximum chaos with minimum effort.
https://hakibenita.com/django-foreign-keys #SQL #HackerNews #ngated
Why Migrations are needed in Entity Framework in C# Tip #107 #coding #dotnet #csharp #sql #linq #codingforbeginners #codingbasics #sqlserver #webdevelopment #softwareengineer #visualstudiocode #databases #softwaredeveloper #computerscience #codinglife #learncoding #datascience #learntocode #vscode #visualstudio