Leland Richardson, Founder of Tech.Pro has recently published a very interesting article about BQL, his visions of a better query language (than SQL). The deciding feat of his new language proposal is the fact that it is really a superset of SQL itself.
Every week here and in our newsletter, we feature a new developer/blogger from the DZone community to catch up and find out what he or she is working on now and what's coming next. This week we're talking to Nicolas Frankel, IT consultant with 10 years experience in Java and JEE environments.
The author has recently been deceived by his own Dilbertesque attitude when he stumbled upon a buzzword-filled article about Espresso Logic. But the actual product that claims to implement “reactive programming” through a REST and JSON API is frankly impressed by the ideas behind this product.
I’ve been playing around creating new images and containers and debugging my Dockerfile, and I’ve wound up with lots of temporary containers and images. It’s really tedious repeatedly running ‘docker rm’ and ‘docker rmi’, so I’ve knocked up a couple of bash commands to bulk delete images and containers.
Although WordPress have an effective built-in comment management interface, for several tasks like deleting bulk comments it is way easier and quicker to use SQL. In this article, the author is going to show you some super useful SQL queries to manage your WordPress comments more easily.
One common complaint about agile methods is that management doesn’t have the same degree of “control” over projects. We need to stop worrying about this complaint as a vice and start thinking of it as a virtue.
Neil deGrasse Tyson talked some about how stellar of a scientist Carl Sagan was and what an impact Carl had on Neil personally. What a reminder for those of us that have moved into managing and left behind creating. Should our dues, once paid, last forever?
The author started the book Seven Databases in Seven Weeks in order to have better understanding of the different SQL / NoSQL paradigms. What are the pros and cons of each approach and play around with each type. In this post, he wants to share the installation process I had with PostgreSQL on Fedora.
After years writing SQL statements, the author began to develop a mental check-list of things he looked at when trying to improve query performance. These are the things the author checks before moving on to query plans and reading the sometimes complicated documentation of the database he is working on.
Today's little-known git feature (or maybe everyone knows but me? I only found this a few months ago) is for quickly switching between branches. Usually I would switch branches with: git checkout [branchname]
Make sure you didn't miss anything with this list of the Best of the Week in the SQL Zone. This week's best include a how-to on using Hibernate native SQL queries in Grails applications, tips and tricks for SQL's date time arithmetic, part 3 of a series on MaxScale, and more.
VoltDB supports single- and multi-partition transactions. But what if you wanted to run an operation on all data (each partition), but you didn’t want to execute the operation as a multi-part transaction? Here’s how to do that.
Many time, in the middle of developing a user story, the programmer discovers a question about how it’s intended to work. Or the tester, when looking at the functionality that’s been developed, questions if it’s really supposed to work that way.