Video Shopping-Cart

Now Carring Ko'olau Gold, `Alohi & Manaha Tenor `Ukulele Strings

I'm using a low G set of the `Alohi strings on my main tenor and a high G set of Manaha strings on another tenor and really love these strings. I liked them so much I'm making them available right here on my site.

SQL Programming Notes, Links and other Goodies

 

SQLite

SQLite is an embedded SQL database engine.

SQLite is a in-process library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine. The code for SQLite is in the public domain and is thus free for use for any purpose, commercial or private. SQLite is currently found in more applications than we can count, including several high-profile projects.

SQLite is an embedded SQL database engine. Unlike most other SQL databases, SQLite does not have a separate server process. SQLite reads and writes directly to ordinary disk files. A complete SQL database with multiple tables, indices, triggers, and views, is contained in a single disk file. The database file format is cross-platform - you can freely copy a database between 32-bit and 64-bit systems or between big-endian and little-endian architectures. These features make SQLite a popular choice as an Application File Format. Think of SQLite not as a replacement for Oracle but as a replacement for fopen()

SQLite3 is the default database used for Ruby on Rails development.

Links

Situations Where SQLite Works Well

Websites

SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.

Clients for managing SQLite databases

  • SQLite Manager

    CocoaMySQL is an application used to manage MySQL databases (locally or over the internet). It lets you add and remove databases and tables, change fields and indexes, view and filter the content of tables, add, edit and remove rows, perform custom queries and dump tables or entire databases.

  • SQLite Manager, a SQLite client available as a Firefox extension.
  • SQLite Database Browser, a graphical client to access SQLite databases
  • SQLPro SQL Client, another graphical client to work with SQLite databases

MySQL

MySQL is the world's most popular open source database software.

MySQL is the world's most popular open source database software, with over 100 million copies of its software downloaded or distributed throughout its history. With its superior speed, reliability, and ease of use, MySQL has become the preferred choice for Web, Web 2.0, SaaS, ISV, Telecom companies and forward-thinking corporate IT Managers because it eliminates the major problems associated with downtime, maintenance and administration for modern, online applications.

Many of the world's largest and fastest-growing organizations use MySQL to save time and money powering their high-volume Web sites, critical business systems, and packaged software — including industry leaders such as Yahoo!, Alcatel-Lucent, Google, Nokia, YouTube, Wikipedia, and Booking.com.

Links

Clients for managing SQLite databases

  • SQLite Manager

    CocoaMySQL is an application used to manage MySQL databases (locally or over the internet). It lets you add and remove databases and tables, change fields and indexes, view and filter the content of tables, add, edit and remove rows, perform custom queries and dump tables or entire databases.

  • SQLite Manager, a SQLite client available as a Firefox extension.
  • SQLite Database Browser, a graphical client to access SQLite databases
  • SQLPro SQL Client, another graphical client to work with SQLite databases

Tools

 

Development Resources

Database Managers

  • SQLite Manager

    CocoaMySQL is an application used to manage MySQL databases (locally or over the internet). It lets you add and remove databases and tables, change fields and indexes, view and filter the content of tables, add, edit and remove rows, perform custom queries and dump tables or entire databases.

  • SQLite Manager, a SQLite client available as a Firefox extension.
  • SQLite Database Browser, a graphical client to access SQLite databases
  • SQLPro SQL Client, another graphical client to work with SQLite databases

SQL Books

 

0596008643

Learning MySQL
by Seyed M.M. (Saied) Tahaghoghi, Hugh Williams
Publisher: O'Reilly Media, Inc.
Release Date: November 14, 2006
Pages: 618
available at Amazon.com

Whether you're running a business, keeping track of members and meetings for a club, or just trying to organize a large and diverse collection of information, you'll find the MySQL database engine useful for answering questions such as: Which are my top ten fastest-selling products? How frequently does this person come to our facility? What was the highest, lowest, and average score of the team last season?

MySQL, the most popular open-source database, offers the power of a relational database in a package that's easy to set up and administer, and "Learning MySQL" provides all the tools you need to get started. This densely packed tutorial includes detailed instructions to help you set up and design an effective database, create powerful queries using SQL, configure MySQL for improved security, and squeeze information out of your data.

0596514263.png

MySQL Pocket Reference: SQL Functions and Utilities
by George Reese
Publisher: O'Reilly Media, Inc.
Release Date: July 17, 2007
Pages: 132
available at Amazon.com

To help you be more efficient in your work, this handy pocket reference gives you instant reminders on how to use important MySQL functions, especially in conjunction with key parts of the LAMP open source infrastructure. This powerful database system is so rich in features that no administrator or programmer can stay familiar with all of them. MySQL Pocket Reference is an ideal on-the-job companion, well organized to help you find and adapt the statements you need -- quickly.

Updated for the latest versions of this popular database, this edition covers many complex features that have been added to MySQL 5.0 and 5.1, including a section dedicated to stored procedures and triggers. After a brief introduction on installation and initial setup, the book explains:

Thanks for visiting and checking out my site!

Content is always being added and updated. So check-in often. Curt Sheller

INDEX.PHP | Updated: Sunday, 25th July, 2010 @ 08:47pm

Premium Members have access to Premium areas of the site, studio recorded play-along tracks, free books and discounted books and more…
($9.95 for 3 months)
click here for more information.

View Shopping Cart • Checkout   

Share/Bookmark
ad-myamoe.jpg MGM.png ad-Koolau.png ad-AGCUKESTD1.png
ad-forInfo.png
Banners Ads
  • 125x125 Badge (Sidebar-every page) : $20/month (discount rate, $200 for 1 Year)
  • Banner ad on a particular page - contact me for more information and rates.
For More Information

For more information contact curt@curtsheller.com. For available pages visit the ad rates page.

For ALL the lastest news visit
curtsheller.blogspot.com

Curt Sheller Publications is upfront
E-junkie Shopping Cart and Digital Delivery
Top 50 Ukulele Sites

CurtSheller.com

Top Ukulele Sites

Website brought to you by
Curt Sheller
Curt Sheller Publications
www.CurtSheller.com
and hosted by:

BuiltWithBBEdit.png

“Folks, if you haven't stopped by Curt's site, do so right now! ..And get his books, they are fantastic. This guy knows his stuff and is able to pass it along too.” - - Alan Johnson Proprietor, The 4th Peg

“I can highly recommend Curt's Uke books -- I have four of them and they are excelent.” - fatveg - Portland

Scroll to Top
Content

Thanks for Visiting

The wealth of FREE information, lessons, TABs and resources available on this site is supported by your generous purchases of the books, CDs and products on this site. Please support this site by visiting my online store. Thanks, Curt!

Your feedback, questions, suggestions and comments are welcome.

To send feedback use the Site Feedback Form below to submit your feedback.

For general, public, comments visit the guestbook.

Thanks Curt Sheller