Developping for the translation industry RSS 2.0



 Monday, 20 October 2008

Today’s portable app is not a simple application but a full featured database engine: SQLite. SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

From SQLite Website:

SQLite does not need to be "installed" before it is used. There is no "setup" procedure. There is no server process that needs to be started, stopped, or configured. There is no need for an administrator to create a new database instance or assign access permissions to users. SQLite uses no configuration files. Nothing needs to be done to tell the system that SQLite is running. No actions are required to recover after a system crash or power failure. There is nothing to troubleshoot.

SQLite just works.

 

For those who didn’t heard the SQLite name before and have some doubts on the stability and performance of this engine, don’t fear.  This is probably the most widely deployed database engine as of today. Here are some stats on where SQLite is currently used:

  • 125 million copies of Mozilla Firefox [1]. Firefox 3 uses Sqlite for bookmarks and history.
  • 20 million Mac computers, each of which contains multiple copies of SQLite
  • 20 million websites run PHP which has SQLite built in. [2] We have no way of estimating what fraction of those sites actively use SQLite, but we think it is a significant fraction.
  • 300 million downloads of the Skype client software and 100 million registered users [3]. All recent versions of the Skype client use SQLite internally.
  • 20 million Symbian smartphones shipped in Q3 2007 [4] Newer versions of the SymbianOS have SQLite built in. It is unclear exactly how many Symbian phones actually contain SQLite, so we will use a single quarter's sales as a lower bound.
  • 10 million AOL subscribers use SQLite in the AOL email client that comes bundled with their subscription.
  • 10 million Solaris 10 installations, all of which require SQLite in order to boot.
  • Millions and millions of copies of McAfee anti-virus software all use SQLite internally.
  • Millions of iPhones use SQLite
  • Millions and millions of other cellphones from manufactures other than Symbian and Apple use SQLite. This has not been publicly acknowledged by the manufactures but it is known to the SQLite developers.
  • There are perhaps millions of additional deployments of SQLite that the SQLite developers do not know about.

 

Other Portable software posts:

Portable software – Part 1 (Developer tools)

Portable software – Part 2 (Graphic tools)

 

Other posts:

Chuck Norris Programming facts

Monday, 20 October 2008 09:18:02 (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
Portable Software | SQL | Tools
 Thursday, 09 October 2008

Today’s portable software list is all about viewing and editing graphics.

  • Gimp : a free alternative to Photoshop.
  • IrfanView : is a fast graphic viewer with basic image editing features.
  • XNView : an image viewer and converter that supports more then 400 image formats!
  • Anim8or :is a free and portable 3D modeling and character animation program
  • Thursday, 09 October 2008 08:49:54 (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
    Portable Software | Tools
     Thursday, 21 August 2008

    What is a portable program ? : A portable program is a piece of software that you can carry around with you on a portable device and use on any other computer. It can be your email program, your browser, system recovery tools or even an operating system. The coolest part about it, is that all of your data and settings are always stored on a thumbdrive so when you unplug the device, none of your personal data is left behind.

    This is the first of x posts on different portable software/tools.

    • Nvu : Easy-to-use webpage editor. Simple alternative to Dreamweaver and Microsft Frontpage
    • Server2Go : Apache webserver
    • InstantRails : Contains Ruby, Rails, Apache, and MySQL, all preconfigured and ready to run.
    • Putty : Telnet and SSH client
    • Follow-Me IP : Displays your external IP address
    • XAMPP : Integrated server package of Apache, mySQL, PHP and Perl. Just Unzip and Run
    • HTTP File Server : Simple and easy-to-use file server for personal file sharing.
    • CurrPorts : Lets you view a list of ports that are currently in use, along with applications that use them
    • Quick’n Easy FTP Server : Portble FTP Server.
    Thursday, 21 August 2008 16:17:32 (Eastern Standard Time, UTC-05:00)  #    Comments [0] -
    Tools | Portable Software

    Navigation
    Advertisement
    About the author/Disclaimer

    Disclaimer
    The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

    © Copyright 2017
    Stanislas Biron
    Sign In
    Statistics
    Total Posts: 135
    This Year: 0
    This Month: 0
    This Week: 0
    Comments: 1
    All Content © 2017, Stanislas Biron