Articles: 843 | Categories: 148   
   
   
Home Articles Contact Us
 
 
 
 
MySQL Babel (0 Comments)
Admin: Posted Date: April 4, 2010

Translates database queries from native language to proper SQL syntax, provided that a dictionary exists. I published one article on the features of this class (see publications page ).

Coding

This pages collects some of the code I am distributing.Ok, some code is about trivial web services and not at the top of performance, but it can serve as introductory examples to newbies for learning.
Please, let me know about bugs and/or suggestions for further improvement: this is the free spirit of Open Source.

C++

Mobius
This class allows several operations with Mobius Maps. It may help to lessen operations with Kleinian groups, for example.

Image Allocator
This class allocates space (indexed or with arbitrary number of channels) for images in memory. The problem is not so trivial, since they shall be packed according to the system architecture.

Geometrical Assistant
Geometric manipulations of points (axonometries, perspective, mapping 3D to 2D, rotations in 3D) are performed.

Quaternion
A class handling quaternions. Arithmetic operations, algebraic (norm, radius, argument, conjugation, ...) and transcendental functions are also featured.

Sinus Progress Bar
Simple progress bar where the indicator is a sinuisoidal curve.

Coords Remapper

Coordinates conversion from a discrete planar grid into another of arbitrary dimensions.

Palette Builder

  • Color Palette management in RGB or CMYK. Palette generation via preset gradients;
  • Color Cycling;
  • Palette Acquisition from BMP, GIF and FractInt files;
  • Color codes conversion into the following models: XYZ6011, XYZ709, YCC, CMY, ITU, YUV, YIQ, YES, YCbCr, SMPTECRGB, SMPTE240M, HSV, HLS, HSI.


Photo Click
Partial or full screen capturing.

Prompt Edit

Simulation of a DOS prompt-like window for text commands.
See this example.

Libpng-0.71_1
Compiled version of PNG library for Visual C++.

Zlib 0.93
Zlibrary for handling zip archives. Compiled for Visual C++.

Complex
A class handling complex numbers. Arithmetic operations, algebraic (norm, radius, argument, conjugation, ...) and transcendental functions are also featured.

Ray Tracer
Given a grid point approximating a surface, the light reflection over that surface is computed through Lambertian or Phong shading.

Javascript

Dateclass
Class performing date manipulations. Refer to the analogous code in the PHP section for further information.

Calendar
Shows the calendar scheme of a given date, with weekdays. Month and Year can be both switched, as well as the Italian or foreign start weekday. The selected date can be sent to the input edit.
This is useful while compiling forms.

Form Validator
This class checks forms data by adding easy rules based upon regular expressions, so that developers have not to write specific code to handle the form. Usage is immediate and the only effort required is to customize the output function, as the given example shows.

Encryptowords

The famous game where you have to discover the cross words by guessing their letters. You can set up the words and always update the game.

Countdown
This is a small application performing countdown with several additional features.

Tab Master
This class dynamically sets the TABINDEX property for a given sequence of controls. So developers have not to tediously set'em all along the web page any more.
It could be useful for forms with a large number of controls.

Javascript General Purpose

Opacity
Set opacity value to a given object, given the related ID.

Calculate Age
Calculates the age from a given birth date.
Number - Library of functions for numbers manipulation
A library of functions to handle numerical (integer and float) values: rounding and truncation, data type conversion.

OBJ position
How often did you need to know the exact screen coordinates of an element inside a web page?
For example, to place a (floating) layer below one table cell like in a combo box style?

Partita IVA
(For Italians only) Controlla che la sintassi della partita IVA sia corretta.

Web Page Dimensions
Two functions for computing page size, either with or without scrolling.

String object Library of Functions

A library of additional functions embedding into the original javascript String object and featuring

  •  replacement of all occurrances (supports arrays);
  • accents and HTML entities management;
  • data type conversion and recognition;
  • slashes management, stripping Tags out;
  • Euclidean distance between strings.
  • ... and more operations.

PHP General Purpose

PHP web functions
Library of Web functions in PHP. Currently featuring:

  • retrieves client IP address;
  • retrieves client MAC address;

PHP & MySQL

MySQL Babel 0.0.1
Translates database queries from native language to proper SQL syntax, provided that a dictionary exists. I published one article on the features of this class (see publications page ). The supported dictionaries are currently: Italian, French, German, English and Mexican.
This is project is still at an early stage: issues are several and the collaboration of more and more developers is welcomed, expecially translators.
Suggested applications: enabling users to input an arbitrary query or for teaching SQL language.

Mass posting

This is a backend manager performing mass posting to group(s) of e-mail addresses. The data archival relies upon MySQL database management. E-mail can be also posted with an arbitrary number of attachments. The implementation is quite easy: just follow the instructions therein.

MyBackup
Simple interface to save your database into files. Administrators might not want to let users access to all PhpMyAdmin functionalities, but just to a sufficient bunch of resources. It is not intended to clone PhpMyAdmin interface. MyBackup also provides the chance of exporting portions of data into files by means of filtering SQL queries.
P.S.: Multi-languages are supported. Italian and English are currently available. If you like to include your native language and share it together with the community, it will be appreciated.

PHP

FTPeasy
This class handles multiple FTP connections at once for performing any FTP operation through a set of easy commands. For example, developers may want to upload files to multiple servers (to a main and to a backup server).

Codice Fiscale
This is a class for Italian programmers.
You might also be interested in downloading one CSV including names, codes and phone prefix for almost all Italian places.

Counter
Simple Web access counter

D-vote
You can easily implement voting management system and rate the choices with bars.

CAP
CAP is the Italian homologous concept of ZIP postal code. Data are thus related to Italy, but anyone may manage the code for other countries.

Slider
Performs sliding of pictures

Your Voice
A system manager to leave messages (with emoticons) in your site.

INI files manager
INIzialization files are plain text files, endowed with a prescribed syntax and structure. They represent a widely used solution to store settings in Windows based systems, but this method is system indipendent and can be exported to any platform. This class parses one such file structure and performs read/write operations.

Dateclass
This class handles dates and time in several terms. See the related example included inside the package.

Cifra
Translates base 10 numbers into different bases, also including semi-positional Roman base.

Anagrams
This is a class computing the pure anagrams of a given input words or by setting up preset rules.

Primes Factory
Handles primes in several ways.

Guestbook
Record the messages of visitors in your web-site.

Calendar
A calendar is displayed on the screen. A backend form allows maintainers to set up some sort of agenda of appointments, displayed as top down window at the given date or if the related link is clicked.

IP location

Find the ISO 3166-1 country code associated to the input IP address by querying the RIPE database.

 



 

 
 
Add a Comment:
 
(You must be signed in to comment on an article. Not a member? Click here to register)
   
Title:

Comments: