View Posts for Software Engineering
-
Why I Think Flutter Looks Amazing!
It has been a while for me to get excited about a language. PHP was the first language I learned, but I wasn't excited about it. It wasn't until I discovered PHP 5 and OOP that I felt an epiphany! C++ and Java really take the cake for amazing languages. Most recent has been NodeJS with async await! A new contender has come on to the field!
Flutter, a cross platform framework built on the Dart language. It is used to build iOS and Android apps! Usually, when I see this cross platform claim, I say it is too go...
-
Generate SQL queries to update collations for all tables in a DB
Found this gem on another website:
SELECT CONCAT('ALTER TABLE ', tbl.TABLE_SCHEMA, '.', tbl.TABLE_NAME, ' CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;') FROM information_schema.TABLES tbl WHERE tbl.TABLE_SCHEMA = '<TABLENAME>';
This query will generate sql statements to alter all tables in a MySQL db to utf8mb4 collation.
-
Data Collection, Monitoring and Visualization
For the past two years, I've been focused on the problem of moving data from sensors on networked equipment to data sinks for aggregation, monitoring and visualization purposes. The process is what I call a pipeline that achieves the goals of monitoring and visualization.
Some terminology I use are measurement which can be substituted with metric. Observations which are a collection of measurements.Data Collection
Collecting observations is done by agents. Agents can setup a receiving server (stream), poll da... -
I'm surprised at the lack of Media Asset Management software
Few resources on the topic
- http://www.dpci.com/blog/making-case-digital-asset-management
It is odd that not many seem to be doing this. I would think a centralized repository of assets and way to upload things would be in order. Instead of having some weird asset pipeline in nodejs, I could submit all of my assets into a repo with some versioning scheme to follow. I could update assets and/or push to ... -
Performant and Lock-free do not mean what you think
I think of words that have a lack of definition like performant as an indicator of whether an author knows what they are talking about. "Performant" ain't a word and even if it was what does it mean? High performance? By what measure?
Avoid using "Performant": https://english.stackexchange.com/questions/38945/what-is-wrong-with-the-word-performant
Along those lines, lock-free != wait-free and I would/will forgive people for this. Lock-free sounds nice, but the definition does not imply non-blocking or wait-fr... -
Efficient LRU Cache in Java
Fun fun stuff to do in lintcode. I mean we can always incur a linear traversal using a LinkedList if one wanted a simple way to do LRU, but why not challenge myself.public class LRUCache {
public class LRUNode {
Integer key;
Integer data;
LRUNode prev;
LRUNode next;
public LRUNode(int key, int data) {
this.key = key;
this.data = data;
}
}
LRUNode head;
LRUNode tail;
Map nodeMap = new HashMap();
...