SQLite Manager

This is a Mozilla Firefox extension. This works on all platform.

Install the extension with following URL:
https://addons.mozilla.org/en-US/firefox/addon/sqlite-manager/

Launch the SQLite Manager
Click on ‘Tool’ in menu bar and select ‘SQLite Manager’. New window will appear. Database can be created with GUI.

Advertisements

Generating SQLite database using sqlite3

sqlite3 is simple command line utility. After running with command line, user can create the database file with preferred name. Then user can use SQL command to manage the database.

Installing

Download link: http://www.sqlite.org/download.html
Eg: For Windows user, use the following “Precompiled Binaries For Windows” link.

1. Download is a compressed file.  After extract it and select the sqlite3.exe file inside the extracted directory. Then save it.

Eg: I used directory “sqlite” inside the C partition:
C:\sqlite

2. Open the command prompt and goto to the derectory

Eg: command
cd c:\sqlite

Creating Database

1. Enter command “sqlite3 <database_file_name>”.

Eg: Following command to create the helloworld database
sqlite3 HelloWorld.db

2. Then command prompt will show as following.

SQLite version 3.7.10 2012-01-16 13:28:40
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite>

3. Then use the SQL command to create the tables and populating tables.

Eg: SQL command to create a table
sqlite>create table tbl1(one varchar(10), two smallint);

4. After completed data insertion, use “.exit” command to exit the sqlite3.

Eg: Command
sqlite> .exit

For more information, please refer http://www.sqlite.org/sqlite.html

SQLite

SQLite is an ACID-compliant embedded relational database management system contained in a small C programming library.

It is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. SQLite is the most widely deployed SQL database engine in the world. The source code for SQLite is in the public domain.

Lightening

20 shots. 3 opportunities. 1 success.

No wireless remote control.

This is my first time experience of shooting lightening. I pressed the button with finger to take a photos but it caused blurring images.

Referencing Firefox Default Preferences from JavaScript

Firefox preferences denote configuratiosn or some other information saved for Firefox. It can be accessed with URL (about:config) manually.

Steps to view preferences manually:

  1. Open firefox
  2. Enter ‘about:config’ in address bar
  3. Press Enter key
  4. Preferences table will be displayed

Referencing from JavaScript

In some occasion, it is necessary to modify the preferences values by automatically.
The steps necessary to reference the preferences system from within the JavaScript code could have been made simpler, but it is not too bad. First, your file must have access to the Preference Manager component. To do that, you must add the following line of code to your file:

var prefManager = Components.classes["@mozilla.org/preferences-service;1"]
.getService(Components.interfaces.nsIPrefBranch);

Now that you have access to the preference manager you can get and set preferences using getIntPref()/getBoolPref()/getCharPref() and setIntPref()/setBoolPref()/setCharPref(). These functions are very straight forward and have been used in the code samples above.
Following example shows to modify the default home page in Firefox

To get preference value:

var prefString = prefManager.getCharPref("browser.startup.homepage");

To set preferences value:

var prefString = prefManager.getCharPref("browser.startup.homepage", “https://dlak.wordpress.com”);

කිමදෝ නොහැගුනේ

මා නිදනා මේ නිශන්තයේ
නුඹ ආවා හීනයක් ලෙසේ
ඉගි පාන නෙත් අද්දරේ
ඔබ නොවෙද හිතවතියේ

මේ වසන්තයේ අප හමුවුනා
වසත වැසි බිදු වැටෙනා
මදනලයි මේ හමනා
ඔබෙ සුසුමයි මා වෙලනා

සිනහවයි ඔබෙ නැගෙනා
රාවයයි ඔබෙ ඇසෙනා
මතකයයි ඔබෙ මැවෙනා
නින්ද කිම නොයෙනා

Uploadify

Uploadify is a jquery pluging that can be integrated with web site to upload files. It is fully customizable. It is developed based on the mixture of JavaScript, ActionScript to be able to use with any server-side language.

URL: http://www.uploadify.com/

Features:

  • Query Implementation
  • Multiple File Upload CapabilitiesSWFObject Integration
  • Compatibility with Popular Server-Side Languages
  • Highly-Customizable
  • Large Support Community
  • Extensive Documentation with Examples