🔧 Develop
📖 Documentation
📖 (General Purpose) Programming Languages
- freepascal (news): lang ref, (download: releases (sorted), snapshots, binaries: fixes, trunk ), stdlib FCL, LCL
- Lazarus (IDE) (download, trunk + fpc fixes ) (Lazarus Wiki)
📇 NoSql
📇 Sql
- SQL (wikibook)
- SQL for Web Nerds (by Philip Greenspun; Oracle)
- SQL: Which type of join to use when? (wikibook, de)
- SQL style guide proposal
- SQL vs. NoSQL (an overview; see also)
- Considering MySQL? Use something else. Already on MySQL? Migrate. (Thesis: databases fill roles ranging from pure storage to complex and interesting data processing; MySQL is differently bad at both tasks.)
- MySQL: It’s not the best solution out there, but it’s the best solution for many people. (HN discussion)
- Unpublished MySQL FAQ (or: MySQL is free)
- /r/lolmysql/ (
MySQL: The PHP of Databases
)
📇 Sql APIs
- firebirdsql.org: docs, SQL lang ref (most recent), (a bit older), FB 3 Quick Start Guide, all the other reference manuals (fb documentation is a mess); ➘get
- mariadb.com: docs, SQL lang ref, ➘get (10.5; 10.6)
- oracle.com database: docs, SQL language reference: 19, ➘get XE (Express edition)
- postgresql.org: docs, SQL lang ref (12.4) (latest); full text search (since 9.6); ➘get
- Database constraints in Postgres
-
sqlite.org:
docs,
SQL lang ref;
➘get;
extern: sqlitetutorial.net (SQL lang ref in examples)
RegEx(p) (Regular Expressions
)
- Demystifying regex with practical examples
- Regex tricks (PCRE mostly)
- PCRE:
- PCREgrep + PCREtest Commandline utilities (Wx, binaries, PCRE2)
- Regular Expression Language - Quick Reference .NET Framework
📖 JavaScript
- Fun(ctions) The 7 different ways of declaring a JavaScript function (in 2018)
- How it feels to learn JavaScript in 2016
- You might not need JavaScript
- You might not need jQuery
Patterns & stuff
Types
Common
Map, Dictionary, Associative Container, Key Value Container
Other Structured Types
- Type Safety and Money (a current implementation; money+currency as data types)
- D-Money Handling amounts of money safely and efficiently in D
- JSR 354: Money and Currency API (Reference implementation: JavaMoney, doc)
- Floats and Money (esp. with JavaScript's BigDecimals)