Masthash

#sql

Carl Gold, PhD
1 hour ago

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

elblandknipser :verified:
3 hours ago

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

QuanwenZhao
3 hours ago

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

ADMIN magazine
20 hours ago

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

ADMIN Update | November 22, 2023 | Issue 355 | This Week's Feature -- Kea DHCP Server Suite: The Internet Systems Consortium announced the end of life for the standard DHCP daemon in Fall 2022. Its designated successor Kea has been in development for years.
Manuel Strehl 🫏
1 day ago

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

RPGPGM
1 day ago

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

Rafagas Links
1 day ago

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

QuanwenZhao
2 days ago

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

Jobs for Developers
2 days ago

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

Maksudur Rahaman
2 days ago

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

Habr
2 days ago

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

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

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

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

QuanwenZhao
3 days ago

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

Habr
3 days ago

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

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

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

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

Mahmoud Az
3 days ago

Postgres vs SQLite with Litestream

https://changelog.com/shipit/59

#sql #sqlite #Database

Mahmoud Az
3 days ago
QuanwenZhao
3 days ago

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

Paolo Melchiorre
4 days ago

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

Paul
4 days ago

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

Dar Jeeling
4 days ago

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

Habr
4 days ago

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

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

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

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

John-Mark Gurney
4 days ago

@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

QuanwenZhao
4 days ago

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

RPGPGM
5 days ago

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

Marek Küthe
5 days ago

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

A certificate with the title "SQL Island" and the text "Certificate of Completion - This is to certify that Marek Küthe has successfully completed the learning game SQL Island.". Below this, the following is written in small letters: "ID: 46d185a016 URL: http://sql-island.cs.uni-kl.de/cert.php?id=46d185a016". The title is red, the background is white. At the bottom right is "sql-island.de". To the right and left of the main text is a picture of a character that appears in the game.
sbug
5 days ago

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

A laptop, a PLC and a box with buttons and lamps.
RDN
6 days ago

@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

postmodern
6 days ago

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

Joe Lanman
6 days ago

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

Philip Newborough
6 days ago

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

GregCocks
6 days ago

'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.]

screen shot - Figure 3.14 - Executing a SQL in QGIS - Geospatial Analysis With SQL
screen shot - Figure 1.19 - adding extensions to the database - Geospatial Analysis With SQL
screen shot - Figure 7.21 - pgAdmin display showing data output of n=15 hospitals - Geospatial Analysis With SQL
book cover - Geospatial Analysis With SQL
Mike Harrison
1 week ago

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

Larry Garfield
1 week ago

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.

Jobs for Developers
1 week ago
shuttle
1 week ago

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

Paolo Melchiorre
1 week ago

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

robrich
1 week ago

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.

Martin Owens
2 weeks ago

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

#SQL #OReillyMedia #Marvel #squirrelGirl #Parody

A version of an O'REILLY programming book which says:

Unbeatable SQL Girl, We're here to drop tables and pay bills...

A drawing of Marvel's Unbeatable Squirrel Girl by Erica Henderson is in greyscale in the same style as O'REILLY's other books.
Kevin Davin
2 weeks ago

#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! 🚀

1er slide de la présentation `SELECT 'amazing_features' FROM "posgresql"` qui présente une image du film dumbo.

Il s'agit de l'ombre de Dumbo projeté sur un mur en bois bleu
1er slide de la présentation `Let's kustomize our manifests with style 🤩!` qui présente un gros gâteau très coloré

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

Gif of Kakashi "justuing" Naruto in an uncomfortable place. Naruto flies off screen...like my employment just did.
InfoQ
2 weeks ago

#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

Brooke Kuhlmann
3 weeks ago

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

Adam Driscoll
3 weeks ago

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

reverentgeek
3 weeks ago

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.

Output of an SQL query in Markdown format.
Vikki :verified:
3 weeks ago

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

Choropleth map of Thailand showing Bangkok with the most tourist revenue
Djoerd Hiemstra
3 weeks ago

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

Paolo Melchiorre
3 weeks ago

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

ducksauz 🦆
3 weeks ago

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

Jobs for Developers
3 weeks ago
HistorySheWrote
3 weeks ago

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

Juhis
3 weeks ago

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

Tim Ellis 🦝
4 weeks ago

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

gabi
4 weeks ago

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

OddBird
4 weeks ago

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

Claire Giordano ✨
1 month ago

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

Bio pics for guests Dimitri Fontaine & Vik Fearing plus hosts Claire Giordano & Pino de Candia for the Path To Citus Con podcast for developers who love Postgres. Join us for the live recording on Wed Nov 1st at 10:00am PDT.

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

Claire Giordano ✨
1 month ago

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

Elephant mascot with name of this Postgres podcast in big text: Path To Citus Con for developers who love Postgres.

Plus bio pics for the two guests: Dimitri Fontaine & Vik Fearing—and for the hosts Pino de Candia and Claire Giordano.
1hitsong
1 month ago

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.

Liam
1 month ago

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...

PostgresFM
1 month ago

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

Screenshots of Michael and Nikolay mid-recording, the episode title "Over-indexing" against a pink backround with an elephant wearing sunglasses. Because we're cool.

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

🥺 Do join me! #sql #hacktoberfest

reverentgeek
1 month ago

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