Samuel Nitsche

Curiosity-driven software-developer, 10x underpants. Striving for harm-reduction. We don't need more rockstars, we need more mentors.

Germany Joined on Dec 2, 2017 http://developer-sam.de

Work

Software Developer at Smart Enterprise Solutions GmbH

Samuel Nitsche

Feb 10 '21

List Comprehension – What Is It And Does It Only Exist In Python?

#programmingconcepts #100codeexamples #concepts #python

3 min read

Stored Procedures - love or leave 'em?

This! In my observation, a lot of reluctancy to use stored pr...

Oct 22 '21

Advent Of Code 2020 in SQL – Day 5: “Binary Boarding”

I see you're using Postgres' CAST syntax. Would be neat if th...

Dec 9 '20

How to get started with WordPress Theme development

What is SSG? WordPress is a precondition for my use-case, bec...

Jul 17 '20

How to get started with WordPress Theme development

Hm, I tried out that one here yesterday and it seemed to work...

Jul 17 '20

How to get started with WordPress Theme development

Thanks for the encouraging words. The coding is not the probl...

Jul 17 '20

Brag Post

I survived a toxic workplace that actively questioned my ex...

Sep 12 '19

Against 'foo' (and 'bar' too)

I say using foo/bar is a missed opportunity to add context ...

Jun 11 '19

This space intentionally left blank

I often think that there must be a reason for us to have tw...

Apr 22 '19

View all 28 comments

Samuel Nitsche

Dec 15 '20

Advent Of Code 2020 in SQL – Day 10: “Adapter Array”

#adventofcode #sql

3 min read

Samuel Nitsche

Dec 9 '20

Advent Of Code 2020 in SQL – Day 9: “Encoding Error”

#adventofcode #sql

4 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL – Day 8: “Handheld Halting”

#adventofcode #sql

3 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL – Day 7: “Handy Haversacks”

#adventofcode #sql

3 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL – Day 6: “Custom Customs”

#adventofcode #sql

3 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL – Day 5: “Binary Boarding”

#adventofcode #sql

3 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL – Day 4: “Passport Processing”

#adventofcode #sql

4 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL – Day 3: “Toboggan Trajectory”

#adventofcode #sql

3 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL – Day 2: “Password Philosophy”

#adventofcode #sql

2 min read

Samuel Nitsche

Dec 8 '20

Advent Of Code 2020 in SQL - Day 1: "Report Repair"

#adventofcode #sql #plsql

4 min read

Samuel Nitsche

Nov 3 '20

Creating a Matrix-like Virtual Background with JavaScript

#fun #javascript #virtualbackground

5 min read

Samuel Nitsche

Jul 16 '20

How to get started with WordPress Theme development

#help #webdev

21 10

1 min read

Samuel Nitsche

Jul 16 '20

"But that worked yesterday!" or, why you should test with utPLSQL

#testing #utplsql #oracle

11 min read

Samuel Nitsche

Oct 10 '19

OGB Appreciation Day: Explore a utPLSQL test scenario with “force-manual-rollback”

#100codeexamples #plsql #testing #utplsql

4 min read

Samuel Nitsche

Sep 12 '19

Embracing a mentality of prediction – evaluation – exploration

#reflection #learning #life

5 1

2 min read

Samuel Nitsche

Sep 12 '19

Concatenate a List of Strings in PL/SQL

#100codeexamples #plsql #oracle

5 min read

Samuel Nitsche

Aug 2 '19

PL/SQL Object Types: putting the Structure into the Force Powers Table

#100codeexamples #plsql #sql #sqltypes

5 min read

Samuel Nitsche

Jul 31 '19

Structure Force Powers with PL/SQL Object Types

#100codeexamples #plsql #sql #sqltypes

6 min read

Samuel Nitsche

Jul 31 '19

Narrate Star Wars Movies with utPLSQL annotations

#100codeexamples #utplsql

4 min read

Samuel Nitsche

Jun 26 '19

More Pitfalls of the MINUS comparison

#100codeexamples #sql #testing #minus

3 min read

Samuel Nitsche

Jun 11 '19

Testing the Deathstar security with utPLSQL contexts

#100codeexamples #utplsql #plsql #sql

4 min read

Samuel Nitsche

May 9 '19

Improving Tech with Compassionate Coding

#compassionecoding #empathy #reflection

10 min read

Samuel Nitsche

Jun 7 '19

Updating a Table with the Values of a Different One

#100codeexamples #oracle #sql #database

2 min read

Samuel Nitsche

Jun 6 '19

Pitfalls of the MINUS-comparison

#100codeexamples #sql #testing #database

3 min read

Samuel Nitsche

Mar 28 '19

WordPress, ads and Yak Shaving

#reflections #clarity #decisionmaking #personalgrowth

3 min read

Samuel Nitsche

Jun 5 '19

#100CodeExamples – Test updatable views with utPLSQL Cursors

#100codeexamples #plsql #utplsql #oracle

3 min read

Samuel Nitsche

Jun 5 '19

#100CodeExamples – Constants in PL/SQL and SQL

#100codeexamples #plsql #sql #oracle

3 min read

Samuel Nitsche

Mar 22 '19

#100CodeExamples – Only one active protocol

#100codeexamples #sql

2 min read

Samuel Nitsche

Mar 11 '19

#100CodeExamples – Use the force to replace objects

#100codeexamples #plsql #oracle

2 min read

Samuel Nitsche

Feb 21 '19

#100CodeExamples – utPLSQL Cursor Comparison with user-defined Types

#100codeexamples #plsql #utplsql #oracle

3 min read

Samuel Nitsche

Jan 23 '19

#100CodeExamples – PL/SQL Objects: Basics of force-sensitive beings

#100codeexamples #plsql #oracle

2 min read

Samuel Nitsche

Jan 15 '19

#100CodeExamples – PL/SQL BOOLEAN to INT

#100codeexamples #plsql #oracle #sql

2 min read

Samuel Nitsche

Jan 15 '19

#100CodeExamples – SYSDATE vs. CURRENT_DATE

#100codeexamples #sql #utplsql #oracle

2 min read

Samuel Nitsche

Dec 17 '18

#100CodeExamples – utPLSQL’s Suite Hierarchy in action

#100codeexamples #plsql #utplsql #testing

2 min read

Samuel Nitsche

Dec 11 '18

#100CodeExamples – Dynamic values in a String: UTL_LMS

#100codeexamples #plsql #oracle

2 min read

Samuel Nitsche

Dec 6 '18

#100CodeExamples – Unit-Tests for Primary/Secondary Lookup with Cursor Comparison

#100codeexamples #oracle #utplsql

2 min read

Samuel Nitsche

Dec 4 '18

#100CodeExamples – A challenge to learn and teach: Primary/Secondary Lookup

#100codeexamples #sql

3 min read

Samuel Nitsche

Sep 26 '18

BeckDesignRules for Database Developers: Reveals intention – Naming

#sql #readability #softwaredesign #database

7 min read

Samuel Nitsche

Jul 3 '18

BeckDesignRules for Database Developers Part 1: Passes the tests

#sql #testing #designrules #database

13 4

11 min read

Samuel Nitsche

May 21 '18

“You’re a panelist for 2018 CodeTalk Series” – about the struggles of giving a live presentation in a foreign language

#beginners #utplsql #presentation

9 2

4 min read

Samuel Nitsche

Jan 16 '18

Are you sure about what you know?

#dunningkruger #personalgrowth #reflection

10 1

10 min read

Samuel Nitsche

Jan 15 '18

“One does not simply update a database” – migration based database development

#devops #agile #cleancode #database

31 3

10 min read

Samuel Nitsche

Jan 15 '18

Strongholds of confidence: self-testing your database

#uncategorized #oracle #selftesting #softwarequality

12 min read

Samuel Nitsche

Jan 14 '18

There is no clean (database) development without Version Control

#beginners #database #cleancode #vcs

14 1

10 min read

DEV Community is a community of 862,249 amazing developers

Recent comments

Stored Procedures - love or leave 'em?

Advent Of Code 2020 in SQL – Day 5: “Binary Boarding”

How to get started with WordPress Theme development

How to get started with WordPress Theme development

How to get started with WordPress Theme development

Brag Post

Against 'foo' (and 'bar' too)

This space intentionally left blank