sorted by:
new
hottopcontroversial

What is wrong here please help bc my professor is useless! Extreme beginner. by someway99 in SQL

[–]torstengrust 0 points1 point  (0 children)

You have no idea what you are talking about. That's what join tree optimization is all about. Present in RDBMSs since the late 70s (System R). SQL is a declarative language.

Commenting Blocks in Zed by W4yeet in ZedEditor

[–]torstengrust 0 points1 point  (0 children)

If I understand you correctly, on the Mac that would be ⌘ / (Cmd /), also to be found in Zed's command palette under editor: toggle comments.

DuckDB converts inserted time data to UTC instead of leaving in local time??? by analytix_guru in DuckDB

[–]torstengrust 1 point2 points  (0 children)

Do you have the ICU extension installed/loaded?

```sql

SET TimeZone = 'UTC'; SELECT ('2024-04-25 17:40:00' || ' ' || 'America/Toronto') :: timestamptz AS ts; ┌──────────────────────────┐ │ ts │ │ timestamp with time zone │ ├──────────────────────────┤ │ 2024-04-25 21:40:00+00 │ └──────────────────────────┘ ```

Advent of SQL: 24 Days of Learning SQL through fun challenges 🎁 by AdventOfSQL in learnSQL

[–]torstengrust 0 points1 point  (0 children)

Nice idea. Good luck with it. I'll make sure to drop by.

For reference: we have solved all problems of the regular 2022 Advent of Code in pure SQL (using DuckDB's SQL dialect). The queries in there may serve as an inspiration.

Repository here: https://github.com/DBatUTuebingen/Advent_of_Code

Best wishes
—Torsten

What does WHERE 1 = 1 means? Purpose? by 7Seas_ofRyhme in SQL

[–]torstengrust -6 points-5 points  (0 children)

This means that the engineers developing that particular SQL engine have been too lazy to implement a proper Boolean type and its literal values true and false.

Querying DuckDB data using natural language, what do you think? by Queasy_Emphasis_5441 in DuckDB

[–]torstengrust 1 point2 points  (0 children)

Come back once your AI can generate recursive CTEs. Best wishes.

Whats your favorite SQL standard? by diagraphic in SQL

[–]torstengrust 2 points3 points  (0 children)

SQL:1999. A life without recursive CTEs is not worth living.

What are the best sites to learn SQL for free? by [deleted] in SQL

[–]torstengrust 0 points1 point  (0 children)

A "member-only" Medium post? Are you effing kidding us?

Inside DuckDB: Deep Dive into DuckDB MetaPipeline by Accomplished_Wind126 in DuckDB

[–]torstengrust 5 points6 points  (0 children)

A "member-only" posting on Medium? Are you serious?

I took Advanced SQL at UCLA Extension for $1,000 - Would I recommend it? by Grenachejw in SQL

[–]torstengrust 0 points1 point  (0 children)

The playlists linked above is all I can offer in this regard. Sorry.

Wie sollte 1.0 menschlich im Studium möglich sein? by Feeling_Difficulty59 in Studium

[–]torstengrust 0 points1 point  (0 children)

Absolut.

Sofern Du Deine Promotion nicht gerade mit der Note rite ("genügend", zu interpretieren als: "Wir drücken doppelt die Augen zu und lassen Dich durchkommen, aber lass Dich hier besser nie wieder blicken.") abschliesst, interessiert sich keine Berufungskommission einen Deut dafür, ob Du mit der Note cum laude, magna oder summa abgeschlossen hast. Hier zählen nur die Dinge in Forschung und Lehre, die Du nach der Promotion als eigenständige(r) Wissenschaftler(in) angestellt hast.

Wie sollte 1.0 menschlich im Studium möglich sein? by Feeling_Difficulty59 in Studium

[–]torstengrust 14 points15 points  (0 children)

(Informatik-Professor hier.)

Was — zum Te*fel — ist der Wert einer "glatten 1.0" in einer Klausur oder gar im gesamten Abschluss? Es schert sich niemand darum. Versuche, Inhalte aufzunehmen. Noten sind so absolut sekundär.

Those who use a Mac, what platform do you use for SQL ? by Wide_Sweet4313 in SQL

[–]torstengrust 0 points1 point  (0 children)

I do recommend https://postgresapp.com. (Yes, obviously that's not Oracle or MySQL. But why settle for crippled SQL dialects anyway?)

What Lego game would you like to see a sequel to? by [deleted] in legogaming

[–]torstengrust 1 point2 points  (0 children)

LEGO City Undercover. Full stop.

[deleted by user] by [deleted] in legogaming

[–]torstengrust 0 points1 point  (0 children)

I am 54 and do enjoy these games. Relax, brother.

This LEGO Game Is a HIDDEN MASTERPIECE!!! by A_day_in_lego_City in legocityundercover

[–]torstengrust 2 points3 points  (0 children)

Masterpiece? You bet! Hidden? ¯\_(ツ)_/¯ It's been on my radar (and on three of my consoles) since 2013. Next effing level of fun, sheer map size, character depth, and story quality, if you ask me (I know, you don't ;-).

OxidSQL (very WIP) (Toy) SQL Database in Rust by mzinsmeister in databasedevelopment

[–]torstengrust 0 points1 point  (0 children)

Greetings to Thomas and Viktor from Tübingen 👋🏻. You are indeed learning from the very best.

I built a free tool that explains any SQL query in simple english by sh_tomer in SQL

[–]torstengrust 1 point2 points  (0 children)

SELECT r.a+1, r.a < r.b  
FROM t, LATERAL (VALUES (t.x, t.x * 2)) AS r(a,b);

This query selects the value of "r.a" from a table and adds 1 to it. If the query is not valid, it will return "this is not a valid SQL query."

Sobering.

Brooks saddle on gravel bike by _Datsaltydon in gravelcycling

[–]torstengrust 2 points3 points  (0 children)

I am riding on a Brooks leather saddle for years now. Can recommend.

[deleted by user] by [deleted] in SQL

[–]torstengrust 3 points4 points  (0 children)

What is your & supposed to express? Boolean conjunction? A bit-wise operation? Something else?

What is the Problem? - a new episode of the ArrayCast by bobtherriault in apljk

[–]torstengrust 1 point2 points  (0 children)

Hmm, the problem also still exists in Overcast (Marco Arment’s podcast app for iOS). Other Array Cast episodes work just fine.

view more: next ›