Lars Schulz meerestier

When I was a beginner…

This is a little exercise to try remember the things I struggled with, when I got started with web development. It's too easy to forget about those things after years in business. I think it's super important to keep the ability to put yourself back into the position of a beginner from time to time in order to not overcomplicate your own work and to not throw the typical "just" and "simply" sentences at other people, who get started.

The following list is not complete or very detailed. It's really all about writing down some memories quickly. Feel free to follow this experiment for yourself if you think it's useful.

HTML

Breaks. Why the hell doesn't text wrap in the browser when I add a line break to the source code?
Paths: I absolutely struggled with the basic concept of absolute and relative paths and why stuff doesn't get loaded correctly when I messed paths up in URLs.

	#!/bin/bash
	set -e

	show_help() {
	cat << EOF
	Usage: ${0##*/} [-u USER] [-p PASS] [-P PORT] [-H HOST] [DATABASE]
	${0##*/} -h

	Open a standard connection in Sequel PRO.

	// === Convert SQL Compact Edition database file to SQLite database file ===

	// Dump SQL Compact Edition data to SQLite compatible SQL file
	// - Command line tools: https://github.com/ErikEJ/SqlCeToolbox/wiki/Command-line-tools
	// - ExportSQLCE40.exe "Data Source=D:\Northwind.sdf;" Northwind.sql sqlite

	// The SQL file created by the SqlCeToolbox contains GUID data as text.
	// - Connection string with GUID as text: https://www.connectionstrings.com/sqlite/
	// Data Source=c:\mydb.db;Version=3;BinaryGUID=False;
	// - Recommended is to store GUID data as binary instead of text (requires less space)