http://www.hackvalue.nl/en/ These are the latest articles on Hackvalue, the corporate blog of Loco. Fri, 21 Jan 2011 00:00:00 +0200 Fri, 21 Jan 2011 00:00:00 +0200 http://www.hackvalue.nl/en/article/129/digging_deeper_into_awstats http://www.hackvalue.nl/en/article/129/digging_deeper_into_awstats AWstats is a popular program to analyze logfiles. The AWstats files themselves are neat little databases from which you can extract a wealth of information. Tue, 04 Jan 2011 00:00:00 +0200 http://www.hackvalue.nl/en/article/128/finding_out_what_hardware_is_in_a_box_with_lshw http://www.hackvalue.nl/en/article/128/finding_out_what_hardware_is_in_a_box_with_lshw Sometimes you need to know what hardware is in a system, but you don't have specs, or you don't have access to the system. Being able to extract this information directly from the system would then be extremely useful, and this is exactly what lshw does. Sun, 19 Dec 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/127/requesting_remote_json_or_xml_from_a_smarty_template http://www.hackvalue.nl/en/article/127/requesting_remote_json_or_xml_from_a_smarty_template Occasionally it is necessary to get data from another domain to display on a webpage. Using Smarty templates it is very easy to fetch and display remote data in JSON or XML format. Mon, 15 Nov 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/126/adding_sequences_in_phppgadmin http://www.hackvalue.nl/en/article/126/adding_sequences_in_phppgadmin PostgreSQL is a very powerful database engine. A helpful tool for managing PostgreSQL databases is phpPgAdmin. Although it is a good tool some things are a bit quirky. Sat, 13 Nov 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/125/static_assignment_of_arrays_in_smarty_templates http://www.hackvalue.nl/en/article/125/static_assignment_of_arrays_in_smarty_templates Occasionally, you need to fill an array with values for use in a Smarty template without explicitly assigning it in your PHP code. Here are some tricks for creating arrays directly in a template. Fri, 22 Oct 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/123/copying_subversion_repositories_with_history_using_svnsync http://www.hackvalue.nl/en/article/123/copying_subversion_repositories_with_history_using_svnsync Occasionally it is necessary to make a copy of a subversion repository, while preserving the revision history. Sometimes you need to do this without shell access to the server. In those cases, svnsync may solve your problem. Sun, 17 Oct 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/122/security_through_obscurity_with_http_basic_authentication http://www.hackvalue.nl/en/article/122/security_through_obscurity_with_http_basic_authentication One of the undying fallacies of web development is that an application can be secured by requiring that the users authenticate themselves using HTTP Basic Authentication. We regularly have to explain to developers how easy it is to extract the authentication data from a request. So it's probably useful to put this down in writing for future reference. Sun, 19 Sep 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/119/a_google_map_with_company_logo_and_travel_directions_using_jquery http://www.hackvalue.nl/en/article/119/a_google_map_with_company_logo_and_travel_directions_using_jquery Our article describing how to set up Google Map with a company logo and travel directions proves to be popular. One question we've received a few times involves using jQuery in stead of Prototype, so in this article we provide the jQuery version. Tue, 31 Aug 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/75/filtering_mail_server_side_with_sieve_part_1 http://www.hackvalue.nl/en/article/75/filtering_mail_server_side_with_sieve_part_1 Like us, you might receive a lot of mail and read it from different locations, using different mail programs, on different kinds of devices, including mobile. If not all mail is relevant at all times, you might want to look at server side filtering instead of client side filtering. Sat, 14 Aug 2010 00:00:00 +0200 http://www.hackvalue.nl/en/article/116/next_step_mysql_using_views_to_improve_performance http://www.hackvalue.nl/en/article/116/next_step_mysql_using_views_to_improve_performance When developers start using MySQL as a storage backend, they quickly find out how to insert, update, delete, and retrieve data. But often enough, progress tends to stop there, and problems arise when an application needs to scale. This article demonstrates how creating views may be a life saver for an underperforming application.