Martin Sarsini

To Report

June 9th, 2010

toreport
An online marketplace for professional journalistic content based in Italy

To report is a project designed to facilitate the exchange between demand and supply of professional journalistic content.

I have designed the structure for this website and developed the system based on Wordpress.
The front-end site has been designed and built on completely personalized basis, independent from a standard Wordpress configuration. In fact the latter has a function of framework regarding the front-end. The back-end of Journalists is the area that makes full use of WordPress “out of the box” functionality as well as some additional implementations.
PHP and relational database are the main technologies used.
I did write clean HTML and CSS code ready for future maintenance and additions.
Paypal payment system is integrated in this project.

Crìmic Design Studio

May 22nd, 2010

crimic website

Crìmic Design Studio is a multi-disciplinary agency that creates design for print and screen.

Crìmic is based in Umbria in the center area of Italy.

They designing visual identities, corporate images, events and communication campaigns for products, websites, books, posters, playbills, CD booklets, brochures, flyers, catalogs, exhibitions, stickers, signs, labels, t-shirts …

The design was provided directly from Crìmic. I have been involved offering my consultation during the interface planning stage. I have built their website using Wordpress. This allows Crìmc to easily update their content and manage their portfolio of works.

I have wrote clean HTML and CSS code ready for future maintenance and additions. I have used primarily Wordpress’ framework functions to customize the functionality.

Gentili Estate Agent

May 8th, 2010

immobiliare-gentili

Immobiliare Gentili is an Estate Agent based in a small town in a typical beautiful rural area of Italy.

Gentili Estate Agent is based in the town of Todi in Umbria region: a typical rural area in the middle part of Italy. They are, since 30 years, a leader of the property market in their geographical area.

Visit Gentili Estate Agent website

I have worked at this wesbite in collaboration with Crimic studio. My role has been in coding HTML and CSS based on the design that I have been provided.

I have also created a back-end system that allows the client to insert new properties to their database. The client actually had a similar system which was based on an unsuitable technology and caused them issues updating the information.

The new system as been developed with PHP, MySQL and some Javascript to improve the ease of use. A database conversion as been required and all data has successfully been retained and used to populate the new system.

This website is a good example of interesting results that can be achieved with a relatively low budget.

Maurizio Sarsini

December 7th, 2009

crimic website

Stunning visual portfolio of Italian architect and artist Maurizio Sarsini

Maurizio Sarsini is an Italian architect and artist (and also my father).

His artworks suggest subjects that range from figurative to abstract with themes that often suggest imaginary myths and metaphysical spaces.

His paintings have been exhibited internationally particularly in Italy, Australia, Côte dʼIvoire, Iran, New Zealand and Switzerland.

I took care of all aspects of the website. My priority while designing this website was to provide something that would allow users to focus their attention on Maurizio’s artworks. For this reason I decided to use a minimalistic design and avoid the use of any unnecessary graphical frill. I have made a fairly intensive use of Javascript and AJAJ (JSON).

The role of Javascript in this project is to dynamically adapt the content to the browser window of the user. The home page in fact displays a number of images that always fills the entire area of the window. In some situations the images can result to be “cut” however this is part of the effect I did want to achieve: no white space and no dead areas, apart from necessary spacing between works.

Detailed artwork open in the entire available area of the window. The artwork images, when applicable, adapt to entire size of the user’s viewport without any loose in quality and offering great detail.

All javascript and AJAX functionality is fully degradable to guarantee an optimal user experience when the technology is not support from the user-end. This also means that Search Engines can fully access, therefore index, any bit of content of the website.

I have made use, although with moderation, of some CSS3 techniques. All functionality and visual design has been tested over several browsers to guarantee comformity of use. I must admit that the website offers a better experience using Chrome/Firefox/Opera/Safari. This is due to better speed these browsers have processing javascript and one or two visual glitches that make the navigation more appealing.

The website is managed by a simple back-end system designed by myself, this uses MySQL and PHP and allows Maurizio to easily update his portfolio.

Finally I have made an effort in optimizing the overall loading time of the website. Many images and intensive use of Javascript is a weak point of this website. Substantial results have been achieved optimizing loading time using various techniques, just to name a few: use separate subdomains for simultaneous HTTP requests, reduced number of HTTP requests, css and javascript dynamic compression, optimized expires headers.

The Russian Choir

November 22nd, 2009

The Russian Choir is an a cappella choir based in Scotland. Their website is vital to promote their events.

This website was built using Wordpress as a platform for content management. WordPress is a very powerful platform, but “out of the box” does not offer a high level of customization. That is why I worked to make the site according to the specifications needed to provide the content in the best way as possible.

  • Design
  • Installation and customization of WordPress
  • Developmet of a system for managing events
  • Optimization on search engines

working on shared hosting with MySQL stored routines

August 29th, 2009

I have recently been working on a web project that makes intensive use of MySQL database with a few stored functions and procedures. It’s not always straight forward to use and in fact here is my short story.

As I usually do, I started the project running it on my local machine. Once I started transferring operations of the web site to an online environment I started to have a few headaches. I discovered that there weren’t any evident ways I could use the stored routines that I previously created.
I love phpMyAdmin, it’s very powerful and the interface is really usable, ut unfortunately recent versions of this database management software do not support views, functions and stored procedures.
Beside this some hosting providers do not offer SSH/telnet support to connect to the database and perform more advanced operations.

So I have done some googling and some research on phpmyadmin wiki and decided to to install an older version of this database management software, precisely the 2.11.9.5. It worked perfectly for the job. All I had to do was to run my prepared queries in the SQL editor.

However another route is to build a bespoke script that runs on the server. I have found spEditor which is a script based on PHP and it seems to be a valid solution: easy to install and configure, but also less demanding than phpmyadmin.

Bookmarklet for phpmyadmin

August 15th, 2009

Although I don’t make a big use of bookmarklets, I must confess that I find them to be very powerful and useful for either personal and work navigation on the web.

Working as a web developer I have to access several times a back-end areas of web sites. Typing in the web address in the browser’s URL bar can be very time consuming, especially if the URLs conform to a pattern. And this is why I started to think at bookmarklets as a little help for this problem.

In my case I have to access MySql dtabases via phpMyAdmin and most of the websites I work on are hosted on servers using cPanel. This means that the URL to access the hosted databases are almost the same. Only the domain name in the URL changes (eg. www.domain.com:2082/3rdparty/phpMyAdmin/index.php).

The following code is the bookmarklet I have created.

javascript:window.location=%22http://%22+document.domain+%22:2082/3rdparty/phpMyAdmin/index.php%22;

The code can be copied and pasted in the browser bookmarks. To access phpMyAdmin you will just need to be on any page in the domain of the website you wish access the database… and launch the bookmark.

I have added the code in my my delicious account, and I must say that bookmarklets work very well using the delicious bookmarks browser add-on.

Do you need an elevator pitch?

April 14th, 2009

No Need to be Concerned, Little Fly

I have always taken for granted that people could perfectly understand what work I do without needing to give any further explanation to those few words that I’m used to say: I am web developer.

Just recently I’ve reflected on the fact that I am so used to hear people asking me if I can design them leaflets or fix their computer that it even doesn’t surprise me. But it should had surprised me, and it should had made me think much more time ago that the problem is me not helping this people understand what kind of job I do.

How much do other people, who are not in my same working industry, understand what my job role is involves? A few days ago I decided to ask my family and close friends to give me a brief description of what they think my technical skills and daily tasks are, and so I could have a better idea of how they think I spend a big part of my time. Well, I must say some descriptions where quite amusing, others went more close but still inaccuracies and lacks.

The different feedback that I have received made me understand where the lacks are and above all made me understand what level of language I must use in order to give an effective explanation.

I am not a big fan of elevator pitches, they seem to put limits on the creativity and the passion of the intuition of the moment, but I have to admit that it can be used as a guideline. I find it a good idea to have a few sentences that I proved to be effective so they are ready to be adapted and used whenever the situation requires it.

There are many resources on blogs about how to write a successful pitch, if you are interested visit the following resources. My only advice is to avoid whoever sponsors the tips stating how they can make you sell more/earn more, think only about quality tjhat you can provide and how you can be useful for clients and employers.

By the way, this is how I like to describe what I do:

I’m a web developer – which means I help people turn ideas and needs into web applications able to perform powerful functions and manipulate information. My role goes beyond building for the front end view: I also take care of making web sites and applications easy to use and access by all users, secure and simple to maintain.

Italian Wedding Dream

March 14th, 2009

italian-wedding-dream

Italian Wedding Dream organises destination weddings in Umbria in the heart of Italy.

Their wedding planners take care of all the details for Civil or Catholic wedding. An interesting list of wedding themes are available to be viewed through their website along with information about their valuable services.

I have actively collaborated with the client and the graphic designer who was in charge of the identity design. Being able to update the website contents in a quick and slick way was one of the main requirements of the client. I have adopted a solution based on Wordpress and exploited a few of the great functions built in this system in order to satisfy design and navigation requirements.

Back on track

February 24th, 2009

A very quick post to let you know that I am back again. I’ll be blogging once a while about some stuff related to my profession, tricks, hints, tips mainly about PHP, CSS, the web in general… and who knows what else. We all grow up day by day, so we’ll see. Because I am human too, I’ll also blog about some stuff of ordinary life, things that happen in this world and all that stuff that blogs already are full of. Anyway, in one way or the other I wish something about it would be interesting for someone.
I have also revamped my website, took away all that information that probably wasn’t interesting for anyone, I know that I am giving a very minimalistic image of myself but it’s fine, this is just the web.