Flat file databases in PHP
After releasing the beta version of Pritlog 0.412, I started doing performance tests on Pritlog using varying number of posts. When I reached over 500 posts, I started noticing performance issues and slow response times. Crossing 1000, it almost was not responding.This is when I started searching for a better solution for using flat files in PHP. I came across the following solutions of using flat file databases in PHP. These use SQL to retrieve rows from a flat file. Very interesting. But the performance did not improve any as these were still flat files. Anyway, these are interesting and can be very useful.
- http://www.txtsql.com/ - (has an admin like phpmyadmin)
- http://code.google.com/p/phpsimpledb/
- http://sourceforge.net/projects/ffdb-php/
- http://lukeplant.me.uk/resources/flatfile/
http://www.usenet-forums.com/php-language/393159-pure-php-flat-file-databases.html
In many places, I found that Sqlite is recommended for speed and performance. It is much more superior than flat files and also, it is installed by default on most php installations. Hence no separate server install or software required.
Tags: computers - Visits: 200 - Comments: 1
Bash prompt like Dos prompt
I read this interesting and very simple tip on how to convert your linux bash prompt to look like a dos prompt.Here is the link to the original article.
http://www.linuxhaxor.net/2008/07/18/make-your-bash-prompt-look-like-dos-prompt/
Quote from the article:
Add this line to your .bashrc: PS1=’C:${PWD////}>’
This basically changes the format of your prompt, to look like a dos
prompt.
Tags: computers - Visits: 1117 - No Comments
Allway Sync: File synchronization
I already mentioned this in the last post. But thought of having a separate post for this as I love this application.This is a free file synchronization software available from the below link:
http://allwaysync.com/
Here is a statement from their website:
Allway Sync is free file and folder synchronization software for Windows.
Allway Sync uses innovative synchronization algorithms to synchronize your data between desktop PCs, laptops, USB drives and more. Allway Sync combines bulletproof reliability with an extremely easy-to-use interface.
Allway Sync uses innovative synchronization algorithms to synchronize your data between desktop PCs, laptops, USB drives and more. Allway Sync combines bulletproof reliability with an extremely easy-to-use interface.
There are multiple versions available. If you are using this on a USB or using portable apps version, make sure you download the appropriate version from their website.
You can create multiple jobs to synchronize multiple directories. This is the easiest way to keep your computers at two different locations in sync.
Tags: computers - Visits: 108 - No Comments
Carry your applications with you
You might have noticed that some USB sticks come with a menu similar to your start menu and also applications. I have a Sandisk U3 cruzer USB drive and this has an application called U3 that enables this kind of menu and many applications can be installed onto this.There is another way you can achieve the same. You can download Portable apps from the below link.
http://portableapps.com/
Here is a statement from their website:
Now you can carry your favorite computer programs along with all of your bookmarks, settings, email and more with you. Use them on any Windows computer. All without leaving any personal data behind.
Once you have installed the portable apps suite, you can select various portable versions of applications like:
- Mozilla Firefox
- Opera
- Filezilla
There are SSH, Anti virus, directory sync, music players, chat clients etc available as portable apps. This is very interesting and useful.
One portable app I love is called Alway Sync. This is a free program that can be used to keep directories in sync.
Tags: computers - Visits: 110 - No Comments
Software I install on a new PC
Having done this a few times already, I thought of documenting this.As soon as I get a Windows based PC, I usually install the following:
- Openoffice (alternative to MS Office)
- Filezilla (FTP client to transfer files to my websites)
- Mozilla Firefox (free and powerful browser)
- Yahoo messenger (chat software)
- Pidgin (Can do yahoo, google and other chats with this)
- Skype (Voip)
- Gizmo Project(alternative to skype)
- Cdrtfe for windows (lightweight cd writing solution)
- Izarc (alternative to Winzip)
- Context Editor (very good editor for PHP, HTML and in general)
- Revo Uninstaller (Powerful uninstaller)
Most of the above are free and open source. Also, these are proven popular packages.
Tags: computers - Visits: 107 - No Comments