snippet - Convert svg to dxf from Linux command line
11 Jun, 2020
Converting svg to dxf from terminal requires inkscape and pstoedit. I myself am using svgo to cleanup the svg file, haven't tested if it makes difference in some edge cases.
snippet - Validate Date in JavaScript
15 Apr, 2020
How to find out if a Date is indeed a valid Date. Simply instance check will not do it, the date might be "Invalid Date".
written tutorial - Setup Gin (golang) + React + Webpack
25 Mar, 2020
Simple blank "Hello, World!" setup combining Gin (golang) + React + Webpack. Create files with these codes, download dependencies and run.
snippet - Compare values of two tables in PostgreSQL
25 Mar, 2020
Compare values from columns of multiple tables. This query can be used to compare two tables in such manner in postgres.
snippet - Clone/Duplicate a Table in PostgreSQL
25 Mar, 2020
This snippet shows you how you can copy a whole table to another one. Useful if you are about to change data in a table and later need to compare it with EXCEPT.
written tutorial - PHP connect to Azure DB
11 Feb, 2020
This snippet shows you how to connect to Azure database for you to run some scripts for an example. In this example we use ODBC class not through PDO. You need to download two packages from your...
snippet -
11 Jan, 2020
This character appears mostly when you have copied code from somewhere. Some syntax highlighters are poorly made and when you copy code you get bad utf-8 symbols along with it. It doesn't show on...
snippet - PostgreSql return inserted row primary key
28 Nov, 2019
When you have primary keys generated by the database not by the application, then you might need it to be returned. In postgres you have to use RETURNING function in your sql query in order to have...
snippet - ArchLinux: downgrade packages
25 Nov, 2019
How to downgrade packages in ArchLinux. There is a nice package that automates this process for you. For me I ran into an issue with postgresql version update that broke the service. So I downloaded...
snippet - React Semantic UI: Simple drag and drop file field
23 Nov, 2019
An example of a simple dropzone using Semantic UI. Is achieved by using "react-dropzone", which does not provide theming.