Jan-Lukas Else

Thoughts of an IT expert

🔗 Links: XXXX-05

This is a collection of links I stumbled across and found worth sharing. Also see the blogroll for links to blogs I regularly read.


sqlite3 fiddle

Published on in 🔗 Links

With all my SQL and SQLite posts, this link is probably also quite interesting: sqlite3 fiddle.

View

“Common Table Expressions in SQL”

Published on in 🔗 Links

I’m currently working in a project that involves a lot of data processing and therefore databases. This means that we often come into contact with SQL at work and have to write an SQL query at least once a day.

View

“Friendlier SQL with DuckDB”

Published on in 🔗 Links

I come into contact with SQL almost every day, be it at work (Oracle Database) or while developing my blog software (SQLite). I don’t find SQL as bad as some others might, but sometimes SQL could be better.

View

rakyll/hey

Published on in 🔗 Links

If you need a simple tool, that sends some load to your web application or site, you can use hey. You can also use it to measure the performance. It provides a nice overview of the distribution of response times and shows how many requests per second your app served.

View

Published on in 🔗 Links

Did you know that Windows has 52 000 different family emoji combinations? See Emojipedia for more details on family emojis.

View

“Native English speakers are the world’s worst communicators”

Published on in 🔗 Links

English is my second language. My mother language is German, in school I had Latin for a while (but was rather bad at it) and in university I had one semester of Spanish.

View

URL Lengthener

Published on in 🔗 Links

Some people come up with strange ideas when they are a bit too bored. Instead of URL shorteners (I wrote my own, btw.) they invent URL lengtheners. Probably of little practical use, but still a funny idea.

View

OnionShare

Published on in 🔗 Links

I currently have two technical topics that interest me a lot. One is SQLite, of which I am always surprised by its functionality and ease, and the other is Tor, which I find quite interesting because of its encryption and because I recently listened to Edward Snowden’s book “Permanent Record” as an audio book.

View

Two articles about awesome SQLite projects

Published on in 🔗 Links

I found two SQLite related articles in my Pocket list, which I wanted to share.

View

City Roads

Published on in 🔗 Links

The attached picture is a visualization of the streets in my home town. I generated this picture with the website “city roads”. This site has been around for a while, but a link post from Julio Biason reminded me to share the link as well. With this site it is possible to display only the streets of a city or surroundings on a plain background.

🖼️ View

Next

Jan-Lukas Else