Blog
PL/pgSQL Snippet – get_url_params()
One thing that you may need to use from time to time in Postgres is a function to be able to extract the value of a URL parameter from URLs stored in your DB. I wanted to be able to Read more…
Blog
JavaScript Snippet – vueToHTML(…)
Recently I have been writing plugins for Grafana and had a desire to make a panel that would give the user the ability to use the data from the query within HTML with AngularJS syntax. I have not come up Read more…
Blog
PostgreSQL – Recursively Query Hierarchical Data
I recently wrote a post about how to query hierarchical data without recursion in PostgreSQL. Now it is time to talk about how to do it with recursion. 😎 CTEs (Common Table Expressions), AKA WITH clauses, provide us the ability Read more…
Blog
PostgreSQL – Query Hierarchical Data Without Recursion
Hierarchical data stored in a relational database such as PostgreSQL can be tricky to work with. An organization is an example of a hierarchical structure. For example, let’s say that we need to represent employees: Davy Crocket Cindy Cruz George Read more…
Blog
Restore Video Volume Settings in Google Chrome
If you are annoyed by the fact that you can no longer control the volume of native videos in Google Chrome you are not alone. Originally Chrome allowed you to control the volume of videos: Now Chrome’s new video element Read more…
Blog
Ace Editor Vue Component
Making certain JavaScript UI solutions work with Vue can be a bit of a hassle at times especially if you are new to Vue. Ace editor, for example, is a great solution for developer that want to add a syntax Read more…
Blog
JavaScript Example – YourJS.toBase()
Recently I added toBase() to YourJS. The purpose of this function is to make a straight-forward way to convert numbers to a base (from 2 to 36). Of course you can easily use native JavaScript by using Number.prototype.toString(), but the Read more…
Blog
PL/pgSQL Example – Function That Returns A Table
One thing I started doing last week was writing PL/pgSQL functions for each of my JasperReports. Each function essentially just runs and returns the rows of a query. One question that I had for a long time was how can Read more…
Blog
JavaScript Snippet – An Inclusive Range of Numbers – span()
One of the things I understand but dont really like about the range(), which is available in utility libraries such as lodash and YourJS, is that it produces an array of numbers ranging from the starting number to the ending Read more…
Blog
JavaScript RegExp – Match Any Character
If you have used regular expressions in JavaScript before you probably know that you can match any non-line-terminating character with just the dot (/./). Of course, you may also want to match absolutely any character in which case you can Read more…