After i have removed some log entries in a SQLite DB, I found that the database file size stay the same. This is because SQLite will keep the used space and reuse them later.
We can use the VACUUM command to release the empty space.
sqlite3 <your_sqlite_db_file> "VACUUM;"
Done =)
Reference:
Previously we talked about setting up some custom command in a Django project.
I would like to run the custom command in a regular interval. I could use Linux cronjob but it’s hard to manage and check the run history. It would be great if i could setup and manage these scheduled commands on the Django web portal.
django-chronograph, written by wnielson, is a Python Package which allows us to schedule any django-admin command through the web interface. It works well with the UTC timezone but if you have set the TIME_ZONE in your Django project setting.py, there would be time discrepancy.
For more detail about the bug, you can refer to the Issue #36 – Job doesn’t follow the Django’s TIME_ZONE setting.
Continue reading Django – Schedule django-admin command using django-chronograph
It took me one and an half day to get the Graphite working…
1. Make sure you have pyenv and pyenv-virtualenv installed.
2. Install the following packages.
sudo apt-get install python-dev pkg-config libcairo2-dev memcached
3. Install Python 2.7 with enable-shared.
env PYTHON_CONFIGURE_OPTS="--enable-shared" pyenv install 2.7.8
Continue reading Install Graphite under pyenv virtualenv on Ubuntu
We have the Django welcome page working already.
I would like to create some REST services on that setup. We could make use of the Django REST framework.
Let’s keep working on our <project_root>/django_poc project to manage articles by REST. The example in this post are based on the Django REST framework quickstart tutorial. It’s good to go through all of them which could give you a more thorough idea on how the REST framework works.
1. Install the Django REST framework in your virtualenv.
pip install djangorestframework
Last time we complete the Ruby 1.9.2 installation on Ubuntu Lucid.
Ruby – Installation on Ubuntu Lucid
Similar to the above post, run the following commands in your own account but not root account. Let’s proceed to the Rails 3.0 installation now.
1. Install Rails 3.0
MAMP is Apache, MySQL and PHP runs on Mac. For Mac users, it is very convenient to use the MAMP package such that they don’t need to install the those application one by one. Moreover, MAMP package also bundled with some other useful programs as well as libraries such as phpMyAdmin and the PHP GD library. For more information, you can refer to the MAMP website.
During the installation, you can include the MAMP control panel into you Mac Dashboard. This is quite helpful for you to start and stop the server. you can also pick either PHP4 or PHP5 by switching to the back panel by clicking the i button which is located under the Apache label on the front panel.
Continue reading MAMP – Introduction
I found a good article which the author shows you how to select random records from table among different kind of databases.
Here are the example for SQLite, MySQL and PostgreSQL.
Continue reading SQL – Select Random Records From Table
When you have modified the database during the iPhone Application Development, you have to remove the application in the iPhone Simulator so as to remove the outdated database. Then build and run you latest code and that will apply the new database to the iPhone Simulator.
Continue reading iPhone – Delete Database Cache in iPhone Simulator
Recently, I start learning the iPhone Application Development. If you want to be a iPhone Application Developer, you have to fulfill the following requirements.
Continue reading iPhone – Start Developing Your First iPhone Application
Eureka! 