- 97 Things Every Programmer Should Know (EN)
- Kathrin Passig, Johannes Jander - Weniger schlecht programmieren (DE)
- Peter Seibel - Coders At Work (EN)
- Bill Karwin - SQL Antipatterns (EN)
- Eric Evans - Domain-Driven Design, Tackling Complexity in the Heart of Software (EN)
- Joshua Bloch - Effective Java, 3rd Edition
- Rob Conery - The Imposter's Handbook: Essential CS Skills and Concepts for Self-Taught Programmers
- Michael Nygard - Release It! Second Edition
- Kevin Behr, George Spafford, Gene Kim - The Phoenix Project
- Martin Kleppmann - Designing Data-Intensive Applications
- Marianne Bellotti - Kill It With Fire
- DevOps Tools for Java Developers (Various authors)
- Dan McQuillan - Resisting AI, An anti-fascist approach to artificial intelligence (One of the most important books in the field of AI in 2023 and later)
I'd call those books "Problemsolver". You might not read them from front to back but as a reference for specific problems.
- Thorben Jansen - Hibernate Tips, More than 70 solutions to common Hibernate problems
- Simon Harrer, Jörg Lenhard, Linus Dietz - Java by Comparison
These are non IT specific books, but touch essential things in our business. Either the way we work together or address some common misconceptions, for example sleep being an optional aspect to live:
- Richard Sennett - Together.The Rituals, Pleasures and Politics of Cooperation
- Matthew Walker - Why We Sleep
- Robin DiAngelo - White Fragility (A recommended read for all white developers and a good starter to understand why we need to work actively against racism and not manifest structural racism in our software based solutions)
- Jonathan Taplin - The End of Reality: How Four Billionaires are Selling a Fantasy Future of the Metaverse, Mars, and Crypto (Proper eye-opener, with a lot of history and a semi-optimistic outlook)
- Gavin Mueller - Breaking Things At Work: The Luddites Were Right About Why You Hate Your Job (I don't hate my job, quite the contrary, but this book is both a good history whirlwind and a reassurance that I am not the only one who struggles to understand ongoing automation, enshittification and in general, making billionaires richer by making us all poorer and less autonomous)
- Beate Ritterbach – Vererbung: für Objekte nützlich, für Werte gefährlich (DE)
- Oliver Gierke – Whoops! Where did my architecture go (EN)
- Mark Seemann - Domain modelling with REST(EN)
all.csv
contains an incomplete list of books in my library. The CSV file has 4 columns separated by ;
.
Name | Description |
---|---|
Author | One or more authors, last name, first name separated by & |
Title | Title of the book |
Type | R, S, C (Roman (Fiction), Sachbuch (Non-Fiction), Comic) |
State | R, U (Read, Unread) |
sqlite3 :memory: \
'.mode csv' \
'.separator ,' \
'.import "|curl -s https://github.com/raw/michael-simons/goodreads/master/all.csv" books' \
"SELECT title FROM books WHERE author like '%King%' ORDER by title"
DuckDB is an incredible versatile, in-process SQL OLAP database management system and while most likely total overkill for the small dataset, it's fun. Install and start DuckDB:
-- Required to directly import the csv file from Github
INSTALL httpfs;
-- Just query the dataset
SELECT DISTINCT author FROM read_csv('https://github.com/raw/michael-simons/goodreads/master/all.csv', header=true, auto_detect=true);
-- Create a table named books
CREATE TABLE books AS SELECT * FROM read_csv('https://github.com/raw/michael-simons/goodreads/master/all.csv', header=true, auto_detect=true);
-- Query and manipulate as needed
-- Save the result (overwriting all.csv and sorting it on the way)
COPY (SELECT * FROM books ORDER BY author COLLATE de ASC, title COLLATE de ASC) TO 'all.csv' WITH (header true);
I used to run a browseable, interactive list of all books on Heroku using a free Neo4j AuraDB instance, but Heroku stopped offering a free service a while ago. The repository containing the application code (based on Quarkus) is still available: neo4j-aura-quarkus-graphql project. Follow the instruction in the README.
The essential query to import the CSV into Neo4j looks like this
LOAD CSV WITH HEADERS FROM 'https://github.com/raw/michael-simons/goodreads/master/all.csv' AS row FIELDTERMINATOR ','
MERGE (b:Book {
title: trim(row.Title)
})
SET b.type = row.Type, b.state = row.State
WITH b, row
UNWIND split(row.Author, '&') AS author
WITH b, split(author, ',') AS author
WITH b, ((trim(coalesce(author[1], '')) + ' ') + trim(author[0])) AS author
MERGE (a:Person {
name: trim(author)
})
MERGE (a)-[r:WROTE]->(b)
WITH b, a
WITH b, collect(a) AS authors
RETURN id(b) AS id, b.title, b.state, authors
xsv is a powerful tool for manipulating CSV. Here's an example how to get a list of unique authors
curl -s https://github.com/raw/michael-simons/goodreads/master/all.csv | \
xsv select -d "," Author |\
uniq
If you have JBang installed you can start an admin "UI" like this:
jbang admin.java
Access the page at localhost:8080.