Posts Tagged: sql

Home » sql

Using Spring JdbcTemplate Instead of Object-Relational Mapping

Spring JDBC and Spring JdbcTemplate in particular has become my go-to tool for accessing relational databases for quite some time now and for good reason in my opinion:The common way for using data from an RDBMS in an object-oriented context used to be and for the most part still is object-relational mapping (ORM) frameworks like the Java Persistence API (JPA) or Rails' ActiveRecord. As the name suggests these frameworks attempt to map data (and concepts) from relational, set-oriented data structures, which ... Read more

Keeping database schemas up-to-date with Flyway

At least ever since Ruby on Rails' Active Record Migrations put an emphasis on keeping database schemas consistent with your software's source code both during development and in production database migration tools have become a staple in modern software development.Database migration (or database refactoring as this technique is sometimes called as well) tools allow you to apply data definition language (DDL) statements like "CREATE TABLE ..." or "ALTER ..." to databases in an automated, consistent and traceable manner instead of either ... Read more

Sharing and exploring data models and database patterns

Somewhat in the vein of last week's post, I'd like to share a new service called dbpatterns with you. dbpatterns allows you to create ER models in the browser and share them with other users. If a particular pattern or model suits your needs you can directly export its DDL for PostgreSQL, SQLite, MySQL or Oracle RDBMS.I really appreciate the idea of promoting and sharing best practices for database systems. While object-oriented software design patterns are rather common (though some particular ... Read more

Hands-on SQL Tips: Guard Elements And Window Functions

Sometimes when displaying data in an application you want the amount of data (rows, individual data points etc.) to be limited for the app to stay responsive and to allow the user to more easily scan and browse the data set.In SQL this is commonly done using a LIMIT statement:SELECT * FROM table LIMIT 100Now, what if you want to not only display the data but also inform the user in case the total number of rows in the table ... Read more

Analyzing Large Datasets With SQL

As part of a web application I've created for a client, I've been working on efficient analysis of somewhat large datasets for some time now. This analysis often involves complexing grouping, clustering and value aggregation. SQL and PostgreSQL aggregate functions in particular come in quite handy when dealing with that kind of challenge.While RDBMS and SQL certainly are useful already just for keeping and retrieving data, i.e. for running your usual CRUD operation, those tools really shine when it comes to ... Read more

Modern SQL (with PostgreSQL)

SQL expert Markus Winand some time ago posted an insightful presentation on Modern SQL (mostly PostgreSQL-focussed) at SlideShare.The 116 slides contain plenty of modern SQL idioms you likely haven't used before. Even if you're an experienced SQL developer the presentation is still worth checking out. Read more

ZenQuery is now open source

Today I made ZenQuery available as open source (under the Apache License).ZenQuery is an 'Enterprise Backend as a Service' and allows you to easily access databases through a REST API without any programming knowledge required. Get SQL result sets as JSON, XML or CSV data, which can easily be processed by tools such as MS Excel or in your own applications.ZenQuery provides you with an instant REST API for your SQL queries. Anything that can be expressed by SELECT * FROM ... Read more

Airtable – A true spreadsheet / database hybrid?

Lots of the software of the world is written in Microsoft's Excel. A spreadsheet environment lends itself particularly well to addressing everyday computing problems. Compiling tabular data, creating connections between particular pieces of that data, condensing and aggregating over a dataset's values. These are common tasks a spreadsheet solves very well with no need for complex database or application server software.A spreadsheet is a flexible tool that provides simple, responsive and instant feedback to data input and algorithm changes. However flexible, ... Read more

ZenQuery 1.0 is available today!

A few weeks ago I wrote about a new product I'm currently developing: ZenQuery, an Enterprise Backend as a Service.I’m pleased to announce the first public version of ZenQuery today. Since the first public announcement regarding ZenQuery roughly 30 days ago we’ve been busy working on this release. Today, you’ll be able to try out ZenQuery 1.0 yourselves on your own server and environment. I really hope you like what we’ve got for you so far.For more information please have a ... Read more

ZenQuery: From Idea To Product In 2 Weeks

Earlier this week I've launched a new product called ZenQuery.In a nutshell, ZenQuery is an application that creates an instant REST API (with JSON, XML and CSV formats) for SQL queries. This allows you to easily access any kind of data from your database without having to deal with technical details such as database drivers, connections, ORM or caching.A typical use case is an enterprise company which for example wants to create a new mobile application. The data needed for such ... Read more

By continuing to use the site you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or if you click "Accept" below then you are consenting to this.

Close