• submit to reddit
Nicolas Frankel08/11/14
0 replies

Sanitizing webapp outputs as an an afterthought

For sure, software security should be part of every developer’s requirements: they should be explained and detailed before development. Unfortunately, it happens in real life that this is not always the case. I’ve been thinking about a way to sanitize the output of a large-scale legacy Spring MVC application in a reliable way (i.e. not go on each page to fix issues).

Lukas Eder08/11/14
0 replies

Are You Using SQL PIVOT Yet? You Should!

Every once in a while, we run into these rare SQL issues where we’d like to do something that seems out of the ordinary. One of these things is pivoting rows to columns. A recent question on Stack Overflow by Valiante asked for precisely this.

Robert Greathouse08/11/14
0 replies

Create Your Own Private Docker Registry

Shortly after you start building docker containers you will realize that you need some place to publish your images. You could push to the central docker registry. However, the central registry is public. Not a great idea if you are working on a private project.

Alec Noller08/08/14
0 replies

How to Use Django & PostgreSQL for Full Text Search

Who says you need Solr or Elasticsearch to get full text search going? According to this talk from a recent Django NYC meetup, all you really need is Python and a PostgreSQL database, though there are other options as well.

David Catuhe08/08/14
1 replies

JavaScript: using closure space to create real private members

Closure space properties can be a great way to create really private data. You may have to deal with a small increase in memory consumption but from my point of view this is fairly reasonable.

Abishek Baskaran08/08/14
0 replies

Optiq query push down concepts

Optiq query push down concepts explained.

Chris Travers08/08/14
0 replies

Math and SQL, Part 2: Functions and First Normal Form

There is probably no piece of relational database theory as poorly understood in professional literature as first normal form. This piece seeks to ground an understanding of 1NF in set mathematics not only so that it can be better leveraged but also so that one can be aware of when (and when not) to violate it.

Niels Matthijs08/07/14
2 replies

On Messing Up and Missing Deadlines

Looking at all the projects I've worked on over the years, big or small, there's been one nasty constant. A mistake that creeps up on you at least once a project and puts an indelible mark on all future work. And it has everything to do with not sticking to the optimal workflow.

Michael Mccandless08/07/14
0 replies

A new proximity query for Lucene, using automatons

As of Lucene 4.10 there will be a new proximity query to further generalize on MultiPhraseQuery and the span queries: it allows you to directly build an arbitrary automaton expressing how the terms must occur in sequence, including any transitions to handle slop.

Alec Noller08/07/14
0 replies

SQL Performance Disasters: Your DBA Just Wants to Help

Your DBA just wants to help. And when you're working with large sets of data - or any sets of data, really - sometimes that's the help you need, because small mistakes can quickly balloon into large ones.

Mike Cottmeyer08/07/14
0 replies

Agile in a Remote Workplace World

How do you enable collaboration when team members are working from home? How do remote teams engage in stand up meetings, sprint planning sessions, retrospective meetings, and other Agile ceremonies?

Lukas Eder08/07/14
0 replies

Join the No OFFSET Movement!

Markus Winand from Use The Index, Luke! did it again. He started an exciting battle against one the biggest flaws in the SQL language: OFFSET pagination.

Alec Noller08/06/14
0 replies

Dev of the Week: Andreea Borcea

This week we're talking to Andreea Borca, developer of patient-empowering solutions for the healthcare industry, co-host of Farstuff: The IoT Podcast, and featured author in DZone's 2014 Guide to Internet of Things.

Jeremy Likness08/06/14
0 replies

No Need to $Watch AngularJS "Controller As"

You have to ask yourself what you are watching for, then decide if using an actual $watch is worth it. A $watch introduces significant overhead and fires every digest loop.

Peter Zaitsev08/06/14
0 replies

Q&A: Putting MySQL Fabric to Use

Martin Arrieta and I gave an online presentation last week on “Putting MySQL Fabric To Use.” We were unable to answer all of them in the scheduled time, so here are our replies to all the questions.