If you are looking for a straightforward file upload solution in your Google Web Toolkit/Ext GWT based project, this article might help you. The problem with uploading files in such an application is that we can’t use the GWT RPC infrastructure for this. On the server side, the RemoteServiceServlet expects the request to be a […]
If you are planning to migrate a database application from Oracle to PostgreSQL, this article can help you to understand and solve some of the issues occurring in such a process. PostgreSQL has recently become feature-complete in many areas and therefore porting projects from Oracle might be a feasible option in much more cases. Oracle […]
PostgreSQL users have the option of extending the set of functions and operators available. If you have a common SQL or programmatic routine, custom functions can be an effective way to more succinctly and efficiently accomplish your tasks. Likewise, custom operators can be created to call these functions (or existing built-in functions) in order to […]
When sorting a list of strings in alphabetical order you shouldn’t use the comparison methods of the String class (especially when writing internationalized programs). The String.compareTo method performs a binary comparison of the Unicode characters within the two strings, which is ineffective when sorting in most languages,
PostgreSQL recently added several great new features like Common Table Expressions (CTE), Recursive CTEs, Windowing Functions (my favorite) and Parallel restoring of dumps. The goal of this article is to provide an overview of the new PostgreSQL Windowing Functions. Previously limited to enterprise databases such as Oracle and DB2, they open up a completely new […]
iText is a Java library for developers looking to enhance web- and other applications with dynamic PDF document generation and/or manipulation. Constructing tables with the iText library can be thought of as an easy task, but there is much more thought that should be put into this when generating large dynamic tables (variable number of […]
In this article we will take a brief look at the Oracle SQL FIRST/LAST aggregate functions that allow you to select a value from the first or last row(s) of a sorted group, when the needed value is not the sort key. For example consider a table “PROJECT_COST” having the following structure and data:
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 you click "Accept" below then you are consenting to this.