#sql

Learn all about event based #featureengineering with #SQL: #livestream #datascience this Saturday 2-December at 11:00AM pacific - Fighting #churn with #datascience #masterclass continues! https://www.twitch.tv/carl24k_datascience

Entwickler, die bei kritischen Inhouse-Anwendungen die Eingabedaten für ein Insert-SQL nicht escapen oder gar auf Bind-Variablen verzichten sollten mit der eigenen Tastatur verprügelt werden … das sind Basics! 🙄 #SQL

The #SQuizL of Tuesday is pretty easy as well.
SQuizL 28-NOV-23
1/6 guesses
🟩🟩🟩🟦🟩🟩🟩
https://bit.ly/SQuizL-game
#SQuizL #SQL

Running SQL Queries on Org Tables

Link: http://yummymelon.com/devnull/running-sql-queries-on-org-tables.html
Discussion: https://news.ycombinator.com/item?id=38440620

#sql

SumUp is hiring Senior Backend Engineer (Golang) - Global Bank

🔧 #golang #java #kotlin #php #api #aws #cicd #docker #kafka #kubernetes #nosql #postgresql #sql #terraform #seniorengineer
🌎 Berlin, Germany
⏰ Full-time
🏢 SumUp

Job details https://jobsfordevelopers.com/jobs/senior-backend-engineer-golang-global-bank-at-sumup-com-oct-20-2023-9dec34?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

We were on a little social media break last week. Check out ADMIN Update to see what you might have missed https://mailchi.mp/admin-magazine/admin-update-kea-dhcp-server-suite #DHCP #Kea #server #HPSF #Kubescape #RockyLinux #SQL #database #Kubernetes #Docker #events

Upstream is hiring Senior Software Engineer, Full-stack JavaScript

🔧 #javascript #typescript #nextjs #react #express #cicd #css #elasticsearch #html #kafka #kubernetes #mongodb #nosql #postgresql #redis #sql #seniorengineer
🌎 Remote; Gerakas, Greece
⏰ Full-time
🏢 Upstream

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-full-stack-javascript-at-upstream-oct-12-2023-f6cfea?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

https://minimalmodeling.substack.com/p/many-explanations-of-join-are-wrong very nice explanation of what LEFT JOINs are and how your mental model of them might be missing some aspects. #sql

I found a number of save files and I used #SQL to learn about when they were saved to, the number of objects within each, and list the objects contained within, without having to do this one save file at a time.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/06/getting-save-file-information-with-sql.html

Code repository from the book "Geospatial Analysis with SQL" by Bonny P McClain and published by Packt which is a practical guide to learning geospatial analysis and mastering spatial SQL syntax #sql

https://github.com/PacktPublishing/Geospatial-Analysis-with-SQL

Cloudflare is hiring Senior Systems Engineer - Durable Objects (DO) and D1

🔧 #csharp #cplusplus #golang #java #javascript #rust #typescript #api #sql #seniorengineer
🌎 Austin, Texas
⏰ Full-time
🏢 Cloudflare

Job details https://jobsfordevelopers.com/jobs/senior-systems-engineer-durable-objects-do-and-d1-at-cloudflare-com-oct-18-2023-ee33a2?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Diligent is hiring Senior Software Engineer (.Net, React, Typescript)

🔧 #dotnet #react #typescript #c #csharp #aws #cicd #docker #nosql #sql #seniorengineer
🌎 Budapest, Hungary
⏰ Full-time
🏢 Diligent

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-net-react-typescript-at-diligent-oct-3-2023-9eb63f?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

The sunshine of Monday indicates my mood at this moment 😊.
SQuizL 27-NOV-23
1/6 guesses
🟦🟩🟩🟩🟩🟩🟩
https://bit.ly/SQuizL-game
#SQuizL #SQL

Blockchain.com is hiring Senior Software Engineer, Principal Trading

🔧 #c #cplusplus #java #python #blockchain #sql #principalengineer #seniorengineer
🌎 United Kingdom, Germany, Portugal, France, Argentina
⏰ Full-time
🏢 Blockchain.com

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-principal-trading-at-blockchain-com-sep-21-2023-435e7c?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Proud to have earned my "Tools of the Trade: Linux and SQL" certificate from Google via Coursera! 🎓🐧 Excited to leverage these essential skills for enhanced proficiency in managing databases and navigating Linux environments. Ready for the next challenge!

Verify It Here : https://lnkd.in/gyEHpgYQ

#Linux #SQL #Cybersecurity

Способы нивелирования ошибочных действий пользователей в ИС

В этой статье я хотел бы поделиться собранной мной информацией о том, как можно противодействовать ошибочным действиям пользователей в информационных системах. Актуальность темы, а также отсутствие единого и чёткого представления об этих методах на просторах сети являются причиной подготовки и публикации этого материала. Я постарался рассмотреть этот вопрос как системный, бизнес-аналитик и специалист по информационной безопасности. В статье будут перечислены 5 методов, а также их преимущества и недостатки. Информация о каждом методе представлена для ознакомления и без подробностей, так как каждый из методов представляет собой большую тему, с который каждый по мере интереса может ознакомиться отдельно.

https://habr.com/ru/articles/776446/

#архитектура_предприятия #erpсистемы #аналитика #sql #информационная_система #бизнесаналитика #бизнесправила #системная_аналитика

Happy Sunday 😜
SQuizL 26-NOV-23
1/6 guesses
🟩🟩🟩🟦🟩🟦🟩
https://bit.ly/SQuizL-game
#SQuizL #SQL

Оптимизация запроса и запрос оптимизации

Как не грабить память, не пытать диск, не мучать кластер. Или делать все это всего одним запросом на Impala к Hadoop. Среди задач аналитиков данных, в рамках которых необходимо иметь дело с большими объемами однотипных данных, выделяются задачи построения витрин данных, автоматизации процессов сбора и обработки данных. Многие аналитики используют различные реляционные базы данных, в таблицах которых хранятся огромные объемы информации, агрегация и доступ к которым может занимать долгое время, поэтому правильное составление и оптимизация запросов к этим таблицам становится критически необходимым фактором для работы аналитиков, инженеров данных и data scientist.

https://habr.com/ru/articles/776398/

#sql #оптимизация_запросов #impala #hadoop #join

Rackspace is hiring Data Engineer II

🔧 #cplusplus #java #python #scala #azure #kafka #mysql #postgresql #powerbi #sql
🌎 Remote; Vietnam
⏰ Full-time
🏢 Rackspace

Job details https://jobsfordevelopers.com/jobs/data-engineer-ii-at-rackspace-com-oct-14-2022-557fa4?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Postgres vs SQLite with Litestream

https://changelog.com/shipit/59

#sql #sqlite #Database

I'm All-In on Server-Side SQLite

https://fly.io/blog/all-in-on-sqlite-litestream/

#sql #sqlite #Database

Wow, I'm happy to learn NEW knowledge from #SQuizL.
SQuizL 25-NOV-23
2/6 guesses
🟦🟩🟩⬜🟨🟨🟦
🟦🟩🟩🟩🟩🟩🟦
https://bit.ly/SQuizL-game
#SQuizL #SQL

I published my second article about database generated columns, using PostgreSQL and new generated fields added in Django 5.0 🤖🐘

I'd be very happy to have your feedback 🤗
https://www.paulox.net/2023/11/24/database-generated-columns-part-2-django-and-postgresql/

#Django #Database #Python #SQL #PoatgreSQL #GeneratedColumn #GeneratedField #ORM

Today I wrote an #SQL query which is 440 lines long. I feel like this is my magnum opus.

Skyflow is hiring Senior Software Engineer, Vault

🔧 #cplusplus #java #python #mongodb #mysql #postgresql #sql #seniorengineer
🌎 Palo Alto, California
⏰ Full-time
🏢 Skyflow

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-vault-at-skyflow-com-sep-28-2023-06b828?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Ich prüfe die Klammern in einem umfangreichen Query, hier zähle ich gerade mit den Fingern einer Hand. Ich habe hier die ersten drei sich öffnenen Klammern, es strecken sich Zeigefinger, dann Mittelfinger, dann Ringfinger. Aber während sich Klammern schließen und wieder öffnen wechselt die Reihenfolge der Finger und am Ende schließt sich die letzte Klammer mit dem Mittelfinger. Und ich glaube das war niederschwellig geplant und dem SQL gegenüber persönlich.

#TeaTime #SQL

Приглашаем на двухдневную онлайн-конференцию для IT-специалистов в финтехе

Ежегодная бесплатная онлайн-конференция ЮMoney Day пройдёт в пятый раз и продлится два дня — 1 и 2 декабря. Вас ждут 18 докладов по 13-ти разным направлениям , среди которых — бэкенд, фронтенд, архитектура, тестирование, DevOps, SQL и другие. Посмотреть программу

https://habr.com/ru/companies/yoomoney/articles/775730/

#devops #openapi #sql #архитектура #менеджмент_проектов #системный_анализ #ssdlc #data_governance #sso

@louis

No, you're not crazy. You're using a domain specific language to do what it's good at, and you're moving compute closer to the data which always improves performance.

It just means you need people experienced with DB/SQL, which isn't as common, which is why people aren't doing it as much.

#sql #webdev #golang #backend #mysql #postgresql

Always learned NEW sql syntax from #SQuizL although attempting the 6 times.
SQuizL 24-NOV-23
6/6 guesses
🟩🟦🟩🟩🟩🟩⬜
🟩🟦🟩🟩🟩🟩⬜
🟩🟦🟩🟩🟩🟩⬜
🟩🟦🟩🟩🟩🟩⬜
🟩🟦🟩🟩🟩🟩⬜
🟩🟦🟩🟩🟩🟩🟩
https://bit.ly/SQuizL-game
#SQuizL #SQL

In the last few days I’m experimenting with substituting CRUD API code with Stored Procedures which directly produce the endpoints JSON as a single-row scalar value. API is then just a wrapper that authenticates, validates input and streams the DB’s JSON directly to the client.

- No ORMs, no SQL generators etc.
- All SQL is where it should belong: in the database
- API does only single „CALL myfunc(…)“ db calls
- A simple centralised error handler can accurately report errors from the database
- No weird mixed row/json columns scanning into structs and re-marshalling everything to JSON
- Codebase is collapsing to 20% (by LOCs)
- Stored Procedures can use wonderfully declarative SQL code
- Response times in the microseconds, even for multiple queries, all happens inside the DB

More side effects:

- the data model can change and evolve without touching the API at all
- Zero deploys mean zero downtime
- the API application is so tiny, I could easily switch it to any programming language I want (yes, even Common Lisp) without worrying about available databases libraries, type mapping and rewriting tens of thousands of lines of intermixed language/SQL-code.

The general direction of the dev industry is heading in the opposite direction. More ORMs, more layers, more database abstraction. More weird proprietary cloud databases with each their own limited capabilities and query language.

So you tell me: Is it crazy? Is it wrong? Why do I have doubts despite everything working out beautifully?

#sql #webdev #golang #backend #mysql #postgresql

Twilio is hiring Software Engineer- L3

🔧 #java #api #rest #aws #cicd #docker #gcp #kafka #kubernetes #nosql #sql
🌎 Bengaluru, India
⏰ Full-time
🏢 Twilio

Job details https://jobsfordevelopers.com/jobs/software-engineer-l3-at-twilio-oct-12-2023-fc0e64?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Learn everything you need to know about commands from a #SQL View
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2022/12/sql-view-gives-ability-to-see.html

SQL Island is a great game that teaches you the basics of SQL in a fun way.

https://sql-island.informatik.uni-kl.de/

#SQL

Using Datasette for tracking my professional activity https://blog.notmyidea.org/using-datasette-for-tracking-my-professional-activity.html #Datasette #Graphs #code #SQL

Using DISTINCT in Parent-Child Relationships https://blog.notmyidea.org/using-distinct-in-parent-child-relationships.html #SQLAlchemy #Python #code #SQL

I’m doing a project at work, that involves making a computer program, that talks to a SQL database, and which turns on outputs on a PLC by communicating with the PLC using the MQTT protocol. 😃💻

#Work #PLC #Project #Csharp #SQL #Database #Coding #Programming #Fun #MQTT #IT

Prisma is hiring Engineering Manager: Prisma Data Platform

🔧 #typescript #nosql #sql #engineeringmanager
🌎 Remote
⏰ Full-time
🏢 Prisma

Job details https://jobsfordevelopers.com/jobs/engineering-manager-prisma-data-platform-at-prisma-nov-6-2023-fae818?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

@postmodern - If "member" isn't meaningful (i.e., useful or informative) then it shouldn't be in the set of valid values for that column. If there is a valid value that is predominant, then it can be set as the default; otherwise, require entry of a valid non-null value.

#SQL #Schema

When should columns have a default value vs. just being NULL? For example, I have a members table with a type column. Defaulting members.type to 'member' seems kind of redundant.
#sql #schema

when designing a database for posts with mutliple images, would you store image filenames as comma separated in an images field, or in a separate images table with a foreign key to the post? Or something else?
#sql #database #postgres

Tuning #SQL LIKE using indexes https://use-the-index-luke.com/sql/where-clause/searching-for-ranges/like-performance-tuning #postgresql

This morning I am mostly writing SQL queries for reports. I've also converted values in a db table column from plain text to json strings to allow for multiple values. Feels a bit hacky, but works ok. Should probably create another table at some point.

#dayjob #json #sql

'Geospatial Analysis With SQL', B.P. McClain, 2022
--
[I received a new version of this book - and so wanted to repost my original review]
--
https://post.news/@/kiwiincolorado/2YW3DEvvhqnlEmAbw2ej6QEWbHH <-- my (solicited) technical book review
--
#GIS #spatial #mapping #BookTwitter #bookreview #review #technicalbook #book #PostGIS #PostgreSQL #geospatial #analysis #SQL #opensource #gischat #spatialstatistics #QGIS #geography @datamongerbonny @PacktPublishing
--
[disclaimers – (i) a publisher’s representative solicited a review of this book and provided an e-book version for that purpose but no recompense, (ii) this is my impartial, personal review - and hence is not an endorsement by my employer, implicit or otherwise.]

Went nuts trying to do what I wanted with sorting and selecting some JSON data from an API that rarely changes. My brain got back to reality. Made an update function hat sticks it all in SQL once a month, and now the app just pulls it as needed, in the order needed from SQL. Duh. Sometimes I get stuck down in the weeds. #JSON #SQL

SQL canonical is more expressive, certainly: Postgres' data types are far more robust than PHP, and you can define views, materialized views, stored procedures, etc. very easily, and then derive PHP code off of them.

But then you have to write #SQL, and it seems some are still allergic to that.

A PHP-centric one would require lots of extra ceremony to match up to SQL. (Attributes, classes that wrap stored procedures and views, etc.) I've tried it, and it's a lot of extra code.

Roblox is hiring Data Scientist, Infrastructure Foundation

🔧 #golang #python #sql
🌎 San Mateo, California
⏰ Full-time
🏢 Roblox

Job details https://jobsfordevelopers.com/jobs/data-scientist-infrastructure-foundation-at-roblox-com-oct-4-2023-f6c532?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

Using #SQL with #Rust 🤖

We wrote a comprehensive guide for using SQLx, the most popular raw SQL library, with Rust!

Check it out: https://www.shuttle.rs/blog/2023/10/04/sql-in-rust

After Django 5.0rc1 release, I updated my generated fields article ✨

I also tried to improve the titles as suggested by @adamchainz whom I thank 🎨

All feedback is welcome 🤗

https://www.paulox.net/2023/11/07/database-generated-columns-part-1-django-and-sqlite/

#Django #Database #Python #SQL #SQLite #GeneratedColumn #GeneratedField #ORM

Xero is hiring Senior Data Engineer (DevOps) - 2 Year Fixed Term

🔧 #python #serverless #aws #cicd #docker #kubernetes #awss3 #sql #terraform #seniorengineer
🌎 Remote; Australia
⏰ Full-time
🏢 Xero

Job details https://jobsfordevelopers.com/jobs/senior-data-engineer-devops-2-year-fixed-term-at-xero-sep-19-2023-ee39ec?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

https://dev.to/canro91/a-quick-guide-to-linq-with-examples-5e58 - a series on getting started with #LINQ in #dotNET. I like the #SQL-like syntax, but these methods are a great way to get your feet wet. Great work https://linkedin.com/in/iamcesaraguirre.

For @teruterubozu who always pronounces SQL as "Squirrel".

#SQL #OReillyMedia #Marvel #squirrelGirl #Parody

#YAML ou #SQL, @kubernetesio ou @postgresql…

L'on se retrouve pour 2 présentations au @capitoledulibre afin de découvrir les meilleurs moyens de vous simplifier votre dev avec #postgresql ou le déploiement avec #kubernetes !

Samedi 18 à 16h30 en A002: https://link.davinkevin.fr/cdl23-kustomize-program
Dimanche 19 à 11h30 en A002: https://link.davinkevin.fr/amazingpg-cdl23-program

Venez nombreux! 🚀

Well, the company I work(ed) for just folded. Poof! 💩⛈️.
No notice, no severance, no nothing. 🤬

So I'm asking for boosts and leads. If anyone needs someone who knows data, please reach out.

I'm located in Seattle, WA. Remote preferred.

Last few titles include: CDO, Head of Data, and Sr. Operations Analyst.

I've worked in gaming, fintech, and B2C/C2C marketplaces most recently.

I'm proficient in Python, SQL, statistics, team management, (almost) all things data-related, and a host of other stuff.

I'm opinionated and anti-capitalist, but I also routinely bring in multiple times my department's cost in profits for the companies I work for.

I'm also hella nice (despite my RBF) and easy to get along with.

God, pitching myself is so awkward.

That's the toot. Thanks.

💜💜💜
Edit: I wanted to say thank you to everyone who is sharing this and a huge thank you to everyone who has reached out with encouragement and leads. This community is amazing.

Edit 2: I'm going through all the replies I got, and will reach out to a lot of you soon. I've just finished updating my resume and LinkedIn.

I realize that I'm going to have to give up some of my anonymity when I respond to people, so I'd really appreciate it if anyone I send my resume or LinkedIn profile to could keep my work and personal life separate. Thank you.
💜💜💜

---

**Gif is of parent company explaining our off-boarding process**

#PleaseBoost #Boost #FediHire #LWF #Layoffs #LookingForJob #LookingForWork #Data #DataScience #Python #SQL #Snowflake #ELT #DataPipeline #Analytics #BusinessIntelligence #CDO #HeadOfData #PleaseHelp #Gaming #Fintech #ChiefDataOfficer #HireAlice #ThankYou

#MySQL 8.2 is now generally available, including support for Read/Write Splitting support!

This long-awaited feature has been introduced in the latest innovation release and helps optimize database performance & scalability.

Details on #InfoQ: https://bit.ly/3svcMOo

#Oracle #SQL #Database #RelationalDatabases

Nice breakdown on the use of UNION or INTERSECT combined with ALL or EXCEPT: https://momjian.us/main/blogs/pgblog/2023.html#November_10_2023

Spoiler: Order of operations is important.

#sql #posgresql

Creating a #SQL Data Grid with #PowerShell Universal and dbatools. https://docs.powershelluniversal.com/samples/apps/sql-data-grid

“#Linux provides a unique advantage: it offers freedom, openness, and immediate utility.” 🐧

Alexandre Barelli has created solutions with #FOSS throughout his #IT career with the Government of São Paulo. Read his story, and learn how #opensource can help power your organization and career next!

https://lpi.org/k9q1

#LPI #tech #Redhat #OpenSUSE #Debian #database #sysadmin #saopaulo #freesoftware #PHP #HTML #CSS #SQL #Apache

If you came to this platform from Twitter, did you download an archive of your Twitter/X data? There’s a lot of interesting stuff in there! Check out my latest blog post on how to use Node.js and DuckDB to query your archive! https://motherduck.com/blog/analyze-x-data-nodejs-duckdb/ #nodejs #duckdb #analytics #datascience #sql

Working through @rotnroll666's book on #DuckDB right now. Already learned something super useful. #DuckDB #CLI can generate #markdown output from #SQL queries.

Day 6 of the #30DayMapChallenge ended up taking me a couple of days due to a lot of bugs, and producing a code file too big to be committed to GitHub without being zipped first...

The theme for day 6 was #Asia, and I decided to plot the provinces of Thailand according to how much tourist revenue they pull in.

As usual you can find all my code, data and the interactive version of the map on my challenge website at the link below.
https://vikkiwalls.github.io/30-Day-Map-Challenge-2023-Live/Day%206.html

(please note - this is quite a heavy duty map, so it will probably need a few seconds for the page to load)

#Python #Pandas #Plotly #Matplotlib #Geopandas #SQL #DataScience #DataVisualisation #GIS

This year, we will experiment with a new automatic grader called #Socoles that will automatically give feedback on open quiz questions that require #SQL solutions. Socoles is developed by Benard Wanjiru. Socoles helps us grade the assignments for more than 300 students in the course. Of course, you will get human feedback too, during the tutorials on Friday morning. #Databases

I published an introduction to database generated columns, using SQLite and the new GeneratedField added in Django 5.0 🤖

I'd be very happy to have your feedback on my article 🤗

https://www.paulox.net/2023/11/07/database-generated-columns-part-1-django-and-sqlite/

#Django #Database #Python #SQL #SQLite #GeneratedColumn #GeneratedField #ORM #DjangoCon

I kind of suck at SQL and thus I'm pretty excited that the inner join I just wrote worked on the first try.

Celebrate your little wins every day.

#sql #winning

Roblox is hiring Senior Software Engineer - Economy Fraud

🔧 #golang #api #nosql #sql #seniorengineer
🌎 San Mateo, California
⏰ Full-time
🏢 Roblox

Job details https://jobsfordevelopers.com/jobs/senior-software-engineer-economy-fraud-at-roblox-com-oct-4-2023-b96869?utm_source=mastodon.world&ref=mastodon.world
#jobalert #jobsearch #hiring

@Sqlswimmer
I saw you hanging out in a fabulous session at #dataweekender
Good luck with your presentation.
#SQL #PowerBI

Wanna query your CSV data with SQL? You don't need to build a database for that.

csvsql is one of the tools in the brilliant csvkit toolbox.

With it, you can query your CSV files with SQL queries directly from your command line.

https://hamatti.org/posts/use-sql-to-query-your-csv-files/

#csv #sql #csvkit #data #query #CommandLine #cli

About a year ago I was laid off from a job I loved at a company I thought I would work for until I retired. I found a new job but shortly after I started they changed the role, leaving neither of us happy, so now I'm on the hunt again.

If you have any leads on remote senior data analysis or data product manager roles, drop me a line. I have loads of #SQL experience & over a decade of building #visualizations in #Tableau. Portfolio: https://ellis.fyi/tim-portfolio/

#fedihire #fedihired #getfedihired

Friends, now that people are aggregating together, which conferences should I keep an eye on for submissions? My content goes beyond databases fundamentals, language agnostic. I can cover automation, schema tracking, observability, etc.

Also Vector databases.

#Python #PHP #Javascript #SQL #GraphDatabases #MySQL #Postgres

OddNews Issue 07 |
We dive into FastAPI path operations and SQLAlchemy for #django developers with @jerivas, intuitive web design strategy for #ux designers with @sondrae, and introduce a new OddTool - the Popover Attribute Polyfill.

#webdev #SQL #webdesign
https://us19.campaign-archive.com/?u=80219aa68d7bad77b9fd2eb93&id=67d2b75a2f

Want to be part of the parallel text chat that happens during the live recording of the #PathToCitusCon #podcast for developers who love Postgres?

When = Wed Nov 1st @ 10:00am PDT
Guests = Dimitri Fontaine + @xocolatl
Topic = How to solve every data problem in SQL
Hosts = Pino de Candia + me!
Where = on the Microsoft Open Source Discord, instructions on how to join in this cal invite: https://aka.ms/PathToCitusCon-Ep09-cal

#PostgreSQL #Postgres #OpenSource #SQL #database #Microsoft

@thibaultamartin 
This one is my favorite and awesome to learn #sql: https://lost-at-sql.therobinlord.com/
And also there is https://flexboxfroggy.com/

This, this is cursed https://github.com/ernestmarcinko/htmx-sql
#htmx #sql #webdev #webdevelopment

ChatGPT 5

#google #bing #webdev #programming #frontend #backend #css #html #javascript #code #ui #ux #apple #ios #macos #memes #joke #php #python #java #sql #database #coder #coding #ml #windows #apple #openai #ChatGPT

I love this Path To Citus Con podcast for developers who love Postgres.

If you want to listen to the live podcast recording—and participate in the parallel live text chat on Discord—of the upcoming Episode 09 w/Dimitri Fontaine & Vik Fearing @xocolatl, mark your calendar!

Wed Nov 1st @ 10:00am PDT

The topic will be "How to solve every data problem in SQL"

#PostgreSQL #Postgres #podcast #OpenSource #PathToCitusCon #SQL #Microsoft

https://aka.ms/PathToCitusCon-Ep09-cal

Don't use DISTINCT as a "join-fixer" - Simple Talk

#SQL #BestPractices #Programming
https://www.red-gate.com/simple-talk/databases/sql-server/t-sql-programming-sql-server/dont-use-distinct-as-a-join-fixer/

I'm a #programming dude who works in #javascript, #react, and #sql by day and #jellyfin and #roku by night.

I love #horror #movies, #punk #music, playing #bass #guitar and #drums, #reading #books, #skateboarding, #vinyl #records, and #opensource #software

I love #popculture and frequently speak in #movie quotes.

Just lost a few hours and braincells thanks to #MariaDB.

Query worked fine on old server, query died on new server.

For some reason FORCE INDEX works fine on MariaDB 10.3 but fails on 10.6 and just infinite loads.

Few hours later, tried a different query hint with STRAIGHT_JOIN and hazza the query is fast on the new server and the old server.

Multiple hours lost to find "STRAIGHT_JOIN" to add to a query <_< #SQL

All work towards moving @gamingonlinux to the new server...

New episode: "Over-indexing"

Nikolay and Michael discuss over-indexing — what we mean by it, the regular issues people discuss about it, as well as a novel one Nikolay has come across and benchmarked recently.

🎧 https://postgres.fm/episodes/over-indexing

📺 https://youtu.be/w-CalJguhT0

#postgresql #sql

Windows

#google #bing #webdev #programming #frontend #backend #css #html #javascript #code #ui #ux #apple #ios #macos #memes #joke #php #python #java #sql #database #coder #coding #ml #windows #apple

To celebrate 🎃 spooky season, I shall pronounce "SQL" as "skull" 💀.

🥺 Do join me! #sql #hacktoberfest

There’s an algorithm thang happening on other platforms. I thought I’d test here, too. It’d be cool to connect with folks who also like to geek out about:

- Software Development
- Node.js, JavaScript
- Music, Musicians
- Illustrations
- Guitars, Bass
- Graphic Design
- Guitar Building
- Databases, SQL
- Analytics
- DuckDB
- Subaru Outbacks
- Amp Modeling, Line6 Helix
- Caricatures
- Procreate
- Affinity Designer
- iPad Digital Art
- Coffee
- Bacon
- Developer Relations, DevRel
- Developer Advocates
- Documentation
- Public Speaking
- Tech Conferences
- Zelda #totk #botw
- Fender, Godin, Duesenberg, PRS

That mostly covers it 😬

#software #music #guitars #illustrations #sql #analytics #duckdb #bass #guitarbuilder
#GraphicDesigner #illustrator
#procreate #affinitydesigner
#line6 #helix #caricatures #coffee #bacon #devrel