Sync PSQL Materialized Views After Debounce Period

Sync PSQL Materialized View After Updates and Debounce Period

You have a PSQL database utilizing a “MV” materialized view and want an automated process to determine if the MV should be refreshed because the underlying tables have changed. It should also wait a period of time between the last known update to a table and then execute the REFRESH MATERIAL VIEW command.

This article will show you how to set up a couple of functions to handle that process on as many MVs as you need. Materialized Views are like actual tables in that their data is stored in a table rather than queried each time it is used, and they are like views in that you can’t modify the data in the MV… and so in order for a materialized view to properly reflect the data in the tables it gets the original data from there has to be an explicit instruction to refresh. Refreshing takes both time and resources, refreshing a materialized view may take long seconds or minutes to complete. In older versions of Postgresql this would even cause data to become temporarily inaccessible (and still will without the use of the CONCURRENTLY parameter circa Postgresql >= 9.4).

MA Web Devs (February WebApp Building Meetup)

Have an interest in developing a “micro web app”, we’ll be creating a calendar booking app for an NPO as a group project! Check out the event on The MA Web Developers Group welcomes any attendees to the event, which will be held on February 11th from 11:00am - 4:45pm.

If your interested in working with web technologies (eg: HTML, JavaScript React, Ember, CSS scss) then your encouraged to come join us. Even if you don’t consider yourself a professional web developer, just know that we’re all “still learning”, in fact, the reason many of us are attracted to web development is because it allows us to be apart of a community that is always “still learning” new things.

Come on down, meet the group and we’ll help you learn (or you can help someone else learn). Any participation will be considered contribution that you could use for your portfolio.

Functional JavaScript Timer Display

In this code challenge, the problem is fairly straightforward; you’ve been given an amount of time in seconds and need to display those seconds so that a human can read them as a timer would to show time in hours, minutes and seconds. All the numbers have to be padded to the tens digit, basically this is a digital clock readout! The cool part is that we’ll do this whole challenge with 1 pretty line of functional JavaScript!

Partial Application With Ember Getter and Setter

There is a more functional approach available for the Ember get and set methods that you may have seen or even been using, get(this, ‘item’) instead of this.get(‘item’) and set(this, ‘item’, value) instead of this.set(‘item’, value). When I first saw this I too wanted to write code like that in my Ember projects, after all, no one is immune to the touch of JS FP fever right? So I destructured the Ember namespace, pulled get and set into the current scope and… the end. Hope you enjoyed this article and thanks for… What? Oh you expected more did’t you? If you don’t think this article should end here then good, neither do I. Let’s take this functional syntax for get and set and give them a little extra whompff. And by “whompff” I mean partial application.

Review of "Grokking Algorithms: An Illustrated Guide for Programmers and Other Curious People"

Recently I read the book “Grokking Algorithms: An illustrative guide for programmers and other curious people” by Aditya Y. Bargava and published by Manning in 2016. I never read a book before checking the inside cover to see the print edition, year and publisher. The year isn’t overly critical for an introductory book into algorithms, especially one that doesn’t focus heavily on implementation. However the publisher is always important and Manning Publications delivers top quality technical reads which was the first reason I decided the book might be worth my while.

The second reason I peeked into “Grokking Algorithms: An Illustrated Guide…” was that my brain hurt, I had been working long hours writing code and felt spending more hours reading code for recreation wouldn’t be beneficial. I’d wanted to learn something useful with wide applications, reasonably new to me, challenging enough to hold my interest while also being quickly picked up and easily put down without requiring too much prerequisite knowledge. I’m demanding of my books as you too should be. I saw “Grokking Algorithms: An Illustrated Guide…” and I grabbed it with the intention of jumping to a chapter from the latter half of the book, maybe bouncing around a bit and taking in some cute illustrations. I had assumed it wouldn’t hold much more value aside from entertaining me while offering glimpses into future topics which might lead to books meeting the reading requirements above and filling time until I found that better read. I didn’t think the phrase “a picture is worth a thousand words” would hold true with illustrations in a technical book. I stand here now corrected, my assumptions all erroneous and having been withdrawn.

MA Web Developers Second Meetup (Sept 10th 2016)

Second Meetup of MA Web Developmers Water View Village, Framingham MA.

Ready for another day of code and community?

You’ve been invited! .. and also you and you and you! The next meeting of the MA Web Developers has been scheduled for Saturday September 10, 2016 from 1pm - 7pm in the awesome community room at Water View Village, Framingham MA. As before, this meetup is free and we welcome any web developers who can make the journey to drink coffee, write code, and become part of our little group.

A couple reccomendations before arriving to the meetup on September 10th would be to remember your GitHub username or email so that you choose to, you can easily access and collaborate on code with other members. If you haven’t already joined the group on, why don’t you go do that now? It’s free. If your new to web development then you might also want to join the FreeCodeCampers meetup group which was started by another one of our members and is going to be hosted in the same location (on a different day). Here’s the link to the MetroWest FreeCodeCampers Meetup Group and here is the link to this events group, the MA Web Developers.

Local Hackathon Milford MA

Web Development Hackathon at the Milford, MA Town Library.

Are you interested in web development? Would you enjoy a day building code and networking with other developers?

You are invited! There will be a day long hackathon held Monday July 25, 2016 from 2pm - 8pm in the Granite Quary room at the Milford, MA Town library. This opportunity to is free and open to New England web developers of any age and skill level. It doesn’t matter if you’ve been programming many years or if you recently your first print “Hello World!”, anyone interested in developing together with other web devs from New England and who wants to get out of the July heat for a day is encouraged to come join us!

This group has been created with support and guidance from the awesome people at The group currently has participants who have attendeed Python and JavaScript courses offered through Udacity’s web development nanodegree catalog. If your just learning to write code, Udacity designs courses in hand with many top tier companies such as Google, GitHub and AT&T (just to name a few). Udacity offers up to date learning paths which you can watch at their website for free!. You don’t have to be a student or a member of Udacity to be apart of this group. This meetup is a non-profit group and encourages any local web devs who want to network new people, write fun code and enjoy an interesting day of hands on learning at the library.

Unlimited Provate Repos for All Premium Github Accounts

This is some pretty cool news. GitHub now has granted unlimited private repos for any paid member. This is so awesome. If your already paying your account will automatically be adjusted to the changes so if your like me and have had to upgrade your account to accommodate your private repos I’m sure you’ll be happy to know you should have a lower Github bill this month.

Those of you who have not ever gotten the dreaded message when creating a new private repo that you were going to have to pay more money to continue should be relieved, now you’ll never have to. From here on out, all paid accounts (both personal and organizations) have unlimited private repos.

Migration From WordPress to Hexo Site Generator

A “static site generator” is an application, in most cases exposing a CLI (command line interface) to build a set of HTML, CSS and JavaScript from your website project and you serve those files as your entire site without the need for a database. No Database means no query optimizations or memcaching. An SSG generates your entire site as nothing more than a collection of front-end resources, and that equates to speed. To the users, these pages act no different than a regular blog, the posts are just “hard-coded”. If you’ve ever used server side caching on your WP site then the concept should be a bit familiar. One method of server caching does attempt to build static content over generating each piece of each page on each page load.

Hexo is a SSG (static site generator) built with Nodejs. Hexo isn’t the top dog on the SSG market, there are some wider used options like Jekyll and Octopress, both are very stable Ruby SSG’s. I chose Hexo because it seems to be building a lot of popularity and I wanted an SSG built on Node. Since the finished site is nothing but HTML, CSS and JavaScript our projects can be setup to use almost any language that compiles/transpiles into browser friendly resources. This means all the code we write will be tied to web development moreso than the language underlying the SSG. There are helper methods specific for Hexo, but in general, all SSG’s I’ve looked into use the same tech so we could easily migrate from a Nodejs SSG to a Ruby, Python or even a Go SSG…