[HowTo] Replace String In Mysql With One Query

Yesterday i was helping my friend's blog. She want to change her domain and move her hosting server for some reasons. She is using wordpress as her blog engine and of course using mysql as database server. To move wordpress blog to another domain you need to change some configuration on the database file. Especially if the data have the absolute path in url (ex: http://www.willbechange.com/bla/bla/post.html).After examine her database file i found that many of data in wp-options using … Read more...

[HowTo] Make User Defined Function In SQLite ADO.NET With C#

Sometime we want to make user defined function and use it in our query to the database. In Ms. SQL Server and Oracle DBMS support user defined function, stored procedure and transactional. Since SQLite is zero configuration, serverless and single database file, SQLite doesn't support user defined function (If you don't know what is SQLite and how to use SQLite ADO.Net with C# please refer to this post). User defined function can be made outside of the SQLite that means you make custom function … Read more...

[HowTo] Use SqLite ADO.NET with C#

SQLite is software library written in C that implement self-contained (very minimal support from external libraries), serverless (read/write process directly to database file), cross-platform (run in any Operating System), zero-configuration (no setup/installation needed), transactional (implement serializeable transaction) SQL database engine. SQLite is relatively small, approx 275 KB in size and single database file.For me SQLite is better solution rather than use MS.Access for medium to … Read more...

[HowTo] Install ImageMagick/Imagick For PHP On Ubuntu

Installing ImageMagick on Ubuntu with PECL is really simple. But i want to share with you how to install it beside to remind myself someday, if i forget how to install it. ImageMagick is a php library for image processing. But they are not developed just for PHP library only, now they have library for Ruby, Perl, Phyton, etc. You can visit their official website here.Let's continue to how to install ImageMagick/Imagick on Ubuntu:Open your terminal Install php-pear if you don't install … Read more...

[TIPS] Get File Extension Easily in PHP

I want to share a tips for you to get file extension in PHP easily. Before i always use the old way to get the file extension, that is using substring and find the last "." (dot), and get the extension. For those who still doing this, i have a tips for you to get the extension easier.You can use pathinfo, with pathinfo you can get information about a file path, here is the example how to use it:That's it! Thank you for visiting my blog and have a nice day... … Read more...

[Tutorial] Groovy and Grails Part 2 – Installing Grails

This is the next article from Grovvy and Grails Part 1 - Introduction that you can read it here. Now we continue to install grails in your machine. Before you continue, there are some requirements to run Grails in your machine, so please read it carefully :)Requirements to install Grails: Java SDK 1.4 or higher and have set your JAVA_HOME variable to the SDK install location. note here, Java OpenSDK and JRE is not working with Grails. Apache Ant 1.6.5 or higher * JUnit (to run the … Read more...

[Tutorial] Groovy and Grails Part 1 – Introduction

What is Groovy? What is Grails? For those who don't know about Groovy and Grails, you are lucky because i'm about to explain Groovy and Grails and how powerful they are in Web Application Technology. Also i will give you some example to help you to understand and start using it!"Groovy is a relatively new dynamic language that can either be interpreted or compiled and is designed specifically for the Java platform." (Beginning Groovy and Grails From Novice To Professional Apress). Groovy … Read more...