r/sqlporn • • Feb 24 '23

chatgpt explains genesis in sql

Post image
78 Upvotes

r/sqlporn • • Nov 18 '15

SQL pie chart | code.openark.org

Thumbnail
code.openark.org
19 Upvotes

r/sqlporn • • Nov 18 '15

Sudoku solver

Thumbnail
sqlite.org
17 Upvotes

r/sqlporn • • Nov 18 '21

Simulating Coin Toss In PostgreSQL

Post image
16 Upvotes

r/sqlporn • • Oct 10 '22

Taking SQL skills from intermediate to expert w/ Ergest Xheblati

11 Upvotes

Are you an intermediate-level SQL practitioner? Are you able to turn most of your thoughts into a SQL queries? If so, Congrats! That's not an easy skill to develop ๐Ÿ‘.

Over time, I've learned that in order to go from SQL intermediate to SQL expert, I need to make my code more efficient, scalable, readable, and easier to debug.

That's why I'm excited about Ergest Xheblati free workshop this Thursday, SQL Patterns Every Analyst Should Know. Ergest is the author of Minimum Viable SQL Patterns, and he's been mastering SQL for 15+ years In his workshop, you'll learn about:

  • Query composition patterns - How to make your complex queries shorter, more legible, and more performant

  • Query maintainability patterns - Constructing CTEs that can be reused. In software engineering, it's called the DRY principle (don't repeat yourself)

  • Query robustness patterns - Constructing queries that don't break when the underlying data changes in unpredictable ways

  • Query performance patterns - Make your queries faster (and cheaper) regardless of specific database youโ€™re using

  • Answers to your questions - Ask Ergest whatever you'd like in the live and interactive Q&A

If you'd like to join me and the other 500+ registrants, sign up here!


r/sqlporn • • Aug 26 '21

SQL Raytracer

Thumbnail
github.com
11 Upvotes

r/sqlporn • • Feb 10 '22

I don't understand this error please help.

Post image
8 Upvotes

r/sqlporn • • Nov 18 '15

This has got to be my favourite example when discussing spatial data...

Thumbnail
michaeljswart.com
8 Upvotes

r/sqlporn • • Nov 18 '15

PostgreSQL Mandelbrot

Thumbnail
twitter.com
8 Upvotes

r/sqlporn • • May 23 '22

Python vs SQL

Thumbnail
startupunion.xyz
6 Upvotes

r/sqlporn • • Nov 18 '15

Roman numerals to decimal

Thumbnail
rdbms-insight.com
6 Upvotes

r/sqlporn • • Nov 18 '15

Snowflakes

Thumbnail explainextended.com
6 Upvotes

r/sqlporn • • Dec 18 '17

Brainfuck interpreter written in SQL. Bonus: It's Russian.

Thumbnail jelf.github.io
5 Upvotes

r/sqlporn • • Apr 14 '22

Manage cloud infrastructure as data in PostgreSQL

3 Upvotes

r/sqlporn • • Feb 15 '19

How to Calculate a Cumulative Percentage in SQL

Thumbnail
blog.jooq.org
3 Upvotes

r/sqlporn • • Jan 02 '16

Happy New Year โ€” SQL porn in the most SFW sense

Thumbnail
explainextended.com
3 Upvotes

r/sqlporn • • Jan 14 '22

Want to know where exactly am I making a mistake here

2 Upvotes

select c.index , c.circuitRef, c.name, c.location, lt.time

from circuits as c

inner join lap_times as lt

on c."index" = lt.circuitId;


r/sqlporn • • Apr 26 '19

Generating Fractals with Postgres

Thumbnail
malisper.me
2 Upvotes

r/sqlporn • • Feb 18 '19

Like and Between Operators in SQL | Like Operator in SQL Server | Betwee...

Thumbnail
youtube.com
2 Upvotes

r/sqlporn • • Mar 19 '18

Deep Neural Network implemented in pure SQL over BigQuery

Thumbnail
towardsdatascience.com
2 Upvotes

r/sqlporn • • Oct 06 '21

adding from diff tables

1 Upvotes

I'm trying to calculate Prepaid Insurance = property taxes + Prepaid interest + HOA Insurance.

Property Taxes -> TABLE: DECKTN & COLUMN: PROPTAXES Prepaid Interest -> TABLE: MG_PIT & COLUMN: PRE_INT HOA Insurance -> TABLE: HOA_INS & COLUMN: PREPAID_INS

I'm trying a left join that goes;

LEFT JOIN( Select PROPTAXES, PRE_INT, PREPAID_INS From e3..DECKTN Left join e3..MG_PIT Left join e3..HOA_INS ) PreINS on PreINS.TLR = K.TLR

Not making much progress


r/sqlporn • • Mar 01 '19

Thinking in MapReduce, but with SQL

Thumbnail
citusdata.com
1 Upvotes

r/sqlporn • • Feb 25 '19

SQL Intersect Operator | Intersect Operator in SQL Server | Intellipaat

Thumbnail
youtube.com
1 Upvotes

r/sqlporn • • Feb 15 '19

Data Types in SQL | SQL Data Types | Different Data Types in SQL | Intel...

Thumbnail
youtube.com
1 Upvotes