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 […]
During the last week, the Ropardo Web Development Team has been working on a web portal based on the open sourced content management system WordPress. I was given the task to create a new template for the new website which would eventually be populated with diverse information, ranging from static facts to fast changing local […]
Convert an array to object (recursively) in PHP.
Every MS SQL Server database consists of at least two physical operating system files and these files are specified when a database is created or altered. One and possibly more (secondary files) are used for the data (as well as indexes and allocation pages) and one for the transaction log.
Some tips to avoid a headacke when dealing with xwiki and xeclipse: Common ground: xwiki version: 2.0, xwiki syntax: 2.0 -> If you need to create new and a lot of new documents in a space and time is limited for this activity, an error may occur when you close and want to reopen some […]
Windows Communication Foundation was official released with .NET 3.0. For those people who are doing connected, distributed systems or are in any way interested in communication aspects of systems, this ought to be a God-send. WCF basically rolled all the different Microsoft messaging formats into one, making it extremely easy to architect the communication layer of simple to complex applications.
It is a good idea to hold your database server inside a virtual machine and run it only if needed. This will save the memory space from being loaded with running services when you don’t need them. But what if you need to import a large database dump file and there is no sufficient space […]
I have spent some time recently trying to integrate Lotus Notes with an existing Java web services consumer. The web service consumer (ProjectRepository) was build on Apache Axis technology and provided the project names my application needed. So I created an Java agent that uses that existing code:
SQL statements can be embedded directly into PowerScript code, allowing you to include PowerScript variables in any area of the statement ,whereas you can’t include them if using PowerBuilder Database painter. To work with variables, the SELECT statement accept the INTO clause, that enable assignment of the result to existent variables. For example: SELECT COUNT(*) […]
After the bomb announcement 6 months ago, Google has open sourced its first operating system under the name Chromium OS, which will be the core for the release of Chrome OS, a year later. As of today, the code for next generation operating system will be fully open, from the code base till the user […]
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.