Category Archive: Programming

Sep 02

pythonGit private repository

I built an online editor for modifying some files. They need to be checked into git after they are edited. Unfortunately there is no direct way of setting the username and password for the git repository. Instead you need to use http authentication, and put the username and password into the URL of the repository. …

Continue reading »

Apr 30

cx_Oracle ORA-24418

I am writing a web portal for a bunch of database tasks, and storing information in an oracle database. I am creating a connection pool but seeing this error. This looks like an ORA-24418 out of sessions error. However when I check the database, there are only 120 of the 1200 available sessions being consumed. …

Continue reading »

Sep 18

Formatting SQL in Oracle

I was looking for a way to format the output from EXPAND_SQL_TEXT and came across this post. I would really rather have something in the database that I could do this with. I would prefer not to spool anything out, but it works very well. Just another SQL beautifier

Sep 24

Unzipping all Zip files in a directory

I don’t know why zip can’t handle multiple inputs, but it cant’. Gzip does just fine unzipping everything in a directory, I use this little “script” all the time on the command line to unzip all the files in a directory. for file in $(ls *.zip) do echo $file unzip -o $file done Its a …

Continue reading »

Jul 03

Automating with Telnet

I have a stupid problem, I have a Bitcoin ASIC called a Hex miner. For some reason every 12 hours the thing slows down from 24GH/sec to 5GH/sec. The only way I have found to solve the problem is to power cycle the controller and the unit itself. This would be a pain since I …

Continue reading »