Tag: database

Firefox databases for better performance

July 29, 2009 by Jason

Since Firefox 3.0, bookmarks, history and most storage is kept in SQLite databases. Also, the default history time span was raised from 9 to 90 days as it became more discoverable and useful thanks to the awesome bar, so depending on your browsing habits it could represent some pretty large databases.

Aas any other database, SQLite databases become fragmented over time and empty spaces appear all around. But, since there are no managing processes checking and optimizing the database, these factors eventually result in a performance hit. So, a good way to improve startup and some other bookmarks and history related tasks is to defragment and trim unused space from these databases.

To do this:

Step 1: get sqlite3, a single file command line SQLite database manager, for your platform (available for Linux, Windows, and Mac OS X).

Step 2: Copy the downloaded binary to your profile folder where all your .sqlite files reside.

Step 3: Close Firefox. Read More»

How to get the password for microsoft access protected file

March 17, 2008 by Jason

It happens some time when you lost the password for a database microsoft access file.

As file is password protected so it will not open up without the correct password entered, in order to solve the problem you can simply use a free password revealing utility by nirsoft.net

It’s called Access PassView, the only limitation with this program is that it works for every password-protected mdb file that created with Microsoft Access 95/97/2000/XP. Read More»

Cover Your Tracks Online

February 10, 2007 by Jason

When, in August 2006, a vendor for AOL released search records on 657,000 AOL users, it was easy to look at the queries associated with specific users and determine what kinds of people they were and ultimately who they were. Your online activities could do end up in a database somewhere. Read the privacy policy of your favorite search engine, and you’ll see what methods it employs to collect valuable data about its users. Then consider how many times you’ve read about security breaches that result in data leaks.

There is a way to remain somewhat anonymous on the most popular of all search engines, Google. Remember that if you have a username log-in with any of the Internet search engines -say, a Microsoft Passport or a webmail account -their systems can build a profile of you. If you’re truly paranoid you may want to delete or cancel any free e-mail accounts that are associated with Web search engines and scrub their cookies from your hard drive. If you use any of the services from Google, such as Wallet, Groups, Gmail, or AdSense, or even if you get paid by Google AdWords on your own Web site, then you have an account that points back to your identity. This means that everything you do within the search can now point back to you as a unique user. See how it’s done… Read More»