Latest Articles
Intro to Ecto
#elixirEcto is the specific component for interacting with databases in the Elixir language. It supports mosts used database systems, the default being PostgreSQL, but Oracle, MySQL, SQLite, and MongoDB a... Read more
20 Oct 2017 - 1 minute readDocker tips
#docker #devopsRecently, I started working with Docker on various projects. So here’s just a bunch of commands I’ve found to be quite helpful while troubleshooting errors with Docker. # List all containers docke... Read more
20 Sep 2017 - 1 minute readBlockchain and IoT
#blockchain #linuxHere’s a small script to open a JavaScript interface to interact with an IoT device. This interface can then be easily incorporated in a larger Blockchain project with real tangible everyday life o... Read more
20 Aug 2017 - 2 minute readImage compression from the command line
#linuxHere’s a small script to compress JPEG images in a folder. Useful to save a few kilobytes of bandwith when serving images from your website. I might improve this script in the future to include mo... Read more
20 Jul 2017 - less than 1 minute readCompress a Whole Linux or UNIX Directory
#linuxOk, that’s a simple one, but it’s always nice to have a quick syntax remainder. So, here’s the best way to compress a whole directory under Linux/UNIX using a shell prompt. This technique is often... Read more
20 Jun 2017 - 1 minute readRestart a hung Oracle database
#oracleOn rare occasions, mostly during a high server load peak or a process failure, an Oracle instance may not accept any connection. Either from regular users as well as SYSDBA. This situation is calle... Read more
20 May 2017 - 1 minute readResolve the ORA-00904 invalid identifier error
#oracleEventually, you’ll issue a valid SQL statement and SQLPlus* will return the error ORA-00904 invalid identifier. First, make sure it’s not a typo and you typed a valid and existing column name. If t... Read more
20 Apr 2017 - 1 minute readHow to write to the alert log
#oracleJuste in case you wondered, yes it is possible to write custom messages directly to the alert log. For this, you’ll have to use the procedure ksdwrt stored in the dbms_system supplied package. This... Read more
20 Mar 2017 - less than 1 minute readPL/SQL loop through a set of values
#oracle #plsqlHere’s a simple trick on how to make a PL/SQL loop iterate through a set of predefined values. This can be useful when you need to perform a report query on a set of Oracle user account, or to quer... Read more
20 Feb 2017 - less than 1 minute readIndex managment
#oracleIn this article, I’ll show you various ways to move an index to another tablespace when you need to reorganize database objects or free some space. Move an index on a different tablespace Simple ... Read more
20 Jan 2017 - 1 minute readShared pool purge
#oracleA few days ago, I was trying to optimize a single SQL statement in a production environment. The statement was using bind variables, so the plan would change to a different (sub-optimal) plan as ad... Read more
20 Dec 2016 - 1 minute readSync Oracle sequences
#oracleIn a database copy scenario, or to fix an applicative bug, you may have to resync sequences. Basically, there’s two ways to achieve this: Drop and recreate the sequence. Artifici... Read more
20 Nov 2016 - 1 minute read