geraldew

Data analyst, database programmer, ancientish.

Melbourne, Australia Joined on Apr 22, 2019 https://gitlab.com/geraldew

Work

Data analyst

Python

SQL (in my sleep), Pascal (in my head), Python (in my future), VBA & MS Access (for my sins).

https://gitlab.com/geraldew/foldatry A tool for managing large amounts of files and folders.

20 posts published

113 comments written

8 tags followed

geraldew

Sep 29

Python Settings with Enumerations Saving and Loading as JSON

#python #json

3 min read

30 PyTricks I've Learned By Joining the Real Python Mailing List.

post script - as it happened I was curious enough about JSON ...

Sep 29

How to use SSH with Git and ssh-agent on Windows

Ah, well that now makes it even more interesting. Even though...

Sep 25

How to use SSH with Git and ssh-agent on Windows

I don't think you're making it clear why you'd want to run th...

Sep 25

30 PyTricks I've Learned By Joining the Real Python Mailing List.

Well it simply didn't in the environment that I was using, in...

Sep 11

30 PyTricks I've Learned By Joining the Real Python Mailing List.

By coincidence I recently encountered the reason why item 7 "...

Sep 10

Ethical source movement, or how to try to fight the evil corporation to use your code

So far, the chief misunderstanding that comes from the Ethica...

Aug 21

[Basic] Python age calculator

It took me quite a lot of clicks to find the place where the ...

Jul 12

Avoiding accidental open-source laundering with GitHub Copilot

Unsurprisingly GitHub considers themselves to be good judges ...

Jul 4

View all 115 comments

geraldew

Jul 24

Supplying encrypted credentials for use on a remote service - via bash, OpenSSL, OpenSSH and Python

#bash #openssl #openssh #python

4 min read

geraldew

Jun 19

Coding Diary 2022-06-17

#vba #database #programming

15 min read

geraldew

Jun 5

Python Tkinter and the vanishing Combobox default value

#python #tkinter

4 min read

geraldew

Jun 3

Some Teradata SQL Fun with Dates Differing by Months

#sql #teradata

7 1

15 min read

geraldew

May 29

Laughing at myself - a small debugging story

#python #unicode

4 min read

geraldew

May 27

My Coding History - Part 2

22 min read

geraldew

Mar 26

Grrr Character Encoding

#unicode #text #programming #database

19 2

10 min read

geraldew

Mar 20

A Windows 10 Update Time Check

1 1

9 min read

geraldew

Mar 2

My Coding History - Part 1

3 1

24 min read

geraldew

Jan 16

Meta Coding - Deriving Algorithms and Seeking Solutions

#programming

1 2

4 min read

geraldew

Dec 19 '21

Some Aphoristic Laws

#data #laws #aphorisms

2 min read

geraldew

Nov 20 '21

A minimal Python Tkinter Parent-Children Data Form

#python #sql #tkinter

2 1

3 min read

geraldew

Oct 28 '21

SQL for detecting contiguous and non-contiguous date spans

#sql

5 min read

geraldew

Oct 28 '21

SQL to derive subsequences

#sql

4 min read

geraldew

Oct 3 '21

A Data Spider in Recursive SQL

#sql

11 min read

geraldew

Jul 5 '21

Ubuntu Linux installation to a USB external drive with EFI boot

#linux #efi

2 5

8 min read

geraldew

Jun 6 '21

Name Coincidences and the Occasional Coder

#python #programming

8 min read

geraldew

May 19 '20

A Common Misunderstanding about Re-licensing

#opensource

4 min read

geraldew

Jan 26 '20

A plea for blogging about SQL

#sql #data #blogging

8 1

2 min read

DEV Community 👩‍💻👨‍💻 is a community of 917,994 amazing developers

8 Week Community Wellness Streak

4 Week Community Wellness Streak

2 Week Community Wellness Streak

1 Week Community Wellness Streak

Three Year Club

Two Year Club

One Year Club

Recent comments

30 PyTricks I've Learned By Joining the Real Python Mailing List.

How to use SSH with Git and ssh-agent on Windows

How to use SSH with Git and ssh-agent on Windows

30 PyTricks I've Learned By Joining the Real Python Mailing List.

30 PyTricks I've Learned By Joining the Real Python Mailing List.

Ethical source movement, or how to try to fight the evil corporation to use your code

[Basic] Python age calculator

Avoiding accidental open-source laundering with GitHub Copilot