Skip to main content


Showing posts from April, 2016

Generate .SQLITE File from .SQL File in Windows

You can generate .SQLite file from .SQL file by using SQLite-CLI. For that purpose, you need to prepare some gears as the following.
1. Sqlite 32-bit DLL
2. Sqlite Tool for Windows (Command Line Tools)
You can download all needs from here.

After you download the items, you need to extract them into a directory for example "C:\\sqlite". Now, in you directory, you will have sqldiff.exe, sqlite3.def, sqlite3.dll, sqlite3.exe, and sqlite3_analyzer.eze. Next, you should add "C:\\sqlite" or your own location into PATH data in Windows environment variable so you can access "sqlite3.exe" from command prompt without full path declaration. In command prompt you can type sqlite3 then the following messages will appear.
Now, you are in SQLite command terminal. First, you need to open the SQL file. Your opened file will be assigned into an in-memory database. Then you can save that in-memory database into a SQLite file. Before you open the SQL file, you need to make …

Upgrading PHP 5 to PHP 7 in Ubuntu

PHP 7 comes with a new version of the Zend Engine, numerous improvements and new features such as: Improved performance: PHP 7 is up to twice as fast as PHP 5.6Significantly reduced memory usageAbstract Syntax TreeConsistent 64-bit supportImproved Exception hierarchyMany fatal errors converted to ExceptionsSecure random number generatorRemoved old and unsupported SAPIs and extensionsThe null coalescing operatorReturn and Scalar Type DeclarationsAnonymous ClassesZero cost asserts Today (12 April 2016), latest Ubuntu release doesn't include PHP 7. You can install PHP 7 from third-party repository such as PPA. PPAs are not bound by the release schedules or policies of Ubuntu so they are free to change versions more frequently, among other things. Ondrey PPA is a popular way of staying more up to date with PHP. Ondrey is the official owner of the PHP tree in Debian, which is upstream from Ubuntu.
To install PHP 7 in Ubuntu you can do the following: 1. Add PPA repository $ sudo apt-get …