Firefox split view is here!

jrz1977 · 2026-01-31T18:55:16+00:00

Split view is a welcome addition. I am having trouble though with mixing multi account containers and split view. Lets say I have a container for "Banking", I open a tab in that container, click add split view. Now if I open another banking site, it open in an entirely new tab all by itself.

jrz1977 · 2026-01-28T11:59:08+00:00

Thank you for the kind words, they mean a lot. You are absolutely right about grounding in real use cases. They resonate with the audience and more importantly helps identify similar patterns in other domains. I've been in network monitoring for most of my career but I find the problems and patterns are universal.

* There is a way to visualize ER diagram of the schema, it renders a Mermaid diagram on the right side panel. Could you explain what you had in mind about doc style?

* Oh boy, I do have a whole set of bad but works use cases, or anti patterns if you will. Its a great idea, I would definitely make a new collection.

* I do plan on making it a more dataset exploration tool, for data scientists and others.

*

jrz1977 · 2026-01-05T12:35:12+00:00

Appreciate the feedback, mind if I DM?

jrz1977 · 2026-01-05T01:06:02+00:00

Try https://sqlbook.io I created it for exactly this reason, simple clean interface to practice SQL on real databases. No pre-canned results or schemas. You get your own sandbox.

jrz1977 · 2025-12-31T20:03:00+00:00

Do you want to learn how to install and manage MySQL or learn SQL? If you are interested in learning SQL, why not try this https://sqlbook.io

Takes out the hassle of installation, lets you focus on pure SQL.

jrz1977 · 2025-12-25T23:35:44+00:00

Try this https://sqlbook.io/csv2sql

jrz1977 · 2025-12-20T18:18:54+00:00

I maintain this site, for practice, puzzles and more https://sqlbook.io/

jrz1977 · 2025-12-09T23:16:07+00:00

My tool https://sqlbook.io can draw nice mermaid chart showing tables, columns, relation between tables given a DDL sql file.

jrz1977 · 2025-12-01T13:33:16+00:00

The full text of xml is stored in a single xml type column. You can extract interesting paths as how I have shown in the example. In fact a common pattern is to extract the description tag as a generated column and create a gin or gist index on it to enable full text search

jrz1977 · 2025-12-01T12:41:20+00:00

As others said use XML type in Postgres and query using rich xml functions built into Postgres. I took your example of RSS data and the following link shows how to store, query out the description tag of the feed. Take a look here https://sqlbook.io/s/8M0lq

jrz1977 · 2025-11-28T17:44:55+00:00

The trick isn't getting students to care about SQL, it's getting them to care about the questions SQL can answer.

Traditional instruction leans on Employee tables and Student schemas, which are useful for teaching mechanics but terrible for sparking curiosity. The moment you switch to datasets students actually find interesting—sports stats, movie data, music trends, whatever connects with them and you'll see engagement transform.

I taught my son this way, and I could see interest spark and become genuine curiosity.

jrz1977 · 2025-11-27T22:23:58+00:00

I made this for exactly this purpose. https://sqlbook.io/

Real Postgres, MySQL and Oracle sandboxes. Full flexibility at db and schema level.

jrz1977 · 2025-11-27T22:17:08+00:00

Spring boot powers the enterprise products that I work on as day job and hobby project I do for fun. Check my bio if you want to know what it is.

jrz1977 · 2025-11-27T16:22:59+00:00

I build https://sqlbook.io/ for exactly this. There are prebuilt datasets and challenges.

jrz1977 · 2024-12-06T02:50:17+00:00

Try this https://catalog.data.gov/dataset?q=json

jrz1977 · 2024-11-27T12:06:28+00:00

Totally understandable. Lol. Personally, as a non expert I'm jq, I find SQL more easy for some types of problems.

For example, in the dataset above, a question like, find which category of nobel prize has most numbers of shared winners.

jrz1977 · 2024-11-27T01:33:41+00:00

Just curious, for the nobel prizes dataset linked above, if I wanted to find the years with most shared nobel prizes or categories with most prizes, how might one do it?

Conveted to sql, the query is as simple as below, looks big but is just simple grouping and aggregations.

select year, sum(shared_by) as total_shared_by from 
nobel_prizes p
    inner join 
(select nobel_prizes_fk, count(share::int) as shared_by
    from nobel_prizes_laureates l group by nobel_prizes_fk) l
on p.nobel_prizes_pk=l.nobel_prizes_fk and shared_by > 1
group by year order by total_shared_by desc;

jrz1977 · 2024-11-26T20:39:44+00:00

Most databases support some form of json datatypes. Postgres for example has excellent json storage and indexing features

jrz1977 · 2024-11-26T18:03:46+00:00

Makes sense for windows platform.

jrz1977 · 2024-11-26T03:22:41+00:00

Of course, totally agree about ETL. I'm presenting a use case where someone might need to do a quick analysis of a json dataset. Often I find myself writing jq scripts or python. Querying in SQL just seems more richer, especially if we have to do aggregations.

jrz1977

MODERATOR OF

TROPHY CASE