Programmatore e consulente Vtiger CRM

The UDF repository for MySQL is a community project that aims to offer an organized collection of open source MySQL user defined functions . MySQL UDFs offer a powerful way to extend the functionality of your MySQL database. The UDFs on this site are all free: free to use, free to distribute, free to modify and free of charge, even for commercial projects.

Sometimes we need to obtain a cumulative sum of a columns in a query. How we can do it? Suppose you have this simple table id|in|out ---------- 1  5  0 2  0  6 3  2  0 4  3  0 5  0  4 and you want obtain the cumulative sum  of the column (in+out) like this id|in|out|sum ------------- 1  5  0   5 2  0  6   11 3  2  0   13 4  3  0   16 5  0  4   20 This following query to do this SELECT a.id, a.in, a.out, -- this is the new column called sum ( SELECT SUM( in + out )   FROM mytable b   WHERE b.id <= a.id ) AS sum FROM mytable a ORDER BY id

Charts are an indispensable part of any data visualization work. People can grok visual representation of data easily than a textual variety. Today there are a huge number of free chart libraries available to display visualizations on websites. Below is a small list of  some of the libraries available for displaying charts using php. pChart - a PHP class to build charts pChart is a PHP class oriented framework designed to create aliased charts. Most of todays chart libraries have a cost, our project is intended to be free. Data can be retrieved from SQL queries, CSV files, or manually provided. This project is still under development and new features or fix are made every week. Focus has been put on rendering quality introducing an aliasing algorithm to draw eye candy graphics. Rendering speed has been dramatically enhanced since the first version, we'll still continue optimising the code!  JpGraph   JpGraph is an Object-Oriented Graph creating library for PHP >= 5.1

VisualVM is a visual tool integrating several commandline JDK tools and lightweight profiling capabilities. Designed for both production and development time use, it further enhances the capability of monitoring and performance analysis for the Java SE platform. Go to VisualVM or see screencast .

Lucid desktop , A web operating system (WebOS) software that allow you setup own web desktop OS online. This open source WebOS is built with PHP and uses a SQL database for storing data. Plus more, Lucid Desktop WebOS is a multi-user application , which is very modular with the support for installable applications. With Lucid desktop WebOS, you can access your media, office documents, and other files anywhere. Meanwhile, user can stay up to date with Twitter, RSS feeds, and what’s happening on the web. Plus more, Lucid Desktop already comes with lots of applications like text editor, calculator, image viewer, simple games, web browser, feed reader, music player and more. With the help of a file manager, you can add-edit-delete files and folders (a context menu makes these steps easier), change the appearance of the desktop with theme support and auto-update the OS to the latest version. Lucid Desktop Main Features: Extremely customizable: Lucid allows you to pick you

sqldf is an R package for runing SQL statements on R data frames, optimized for convenience. The user simply specifies an SQL statement in R using data frame names in place of table names and a database with appropriate table layouts/schema is automatically created, the data frames are automatically loaded into the database, the specified SQL statement is performed, the result is read back into R and the database is deleted all automatically behind the scenes making the database's existence transparent to the user who only specifies the SQL statement. Surprisingly this can at times be faster than the corresponding pure R calculation (although the purpose of the project is convenience and not speed). sqldf is free software published under the GNU General Public License that can be downloaded from CRAN .