Home Accessibility Courses Twitter The Mouth Facebook Resources Site Map About Us Contact
 
Python, Lua and Tcl - public course schedule [here]
Private courses on your site - see [here]
Please ask about maintenance training for Perl, PHP, Java, C, C++, Ruby, MySQL and Linux / Tomcat systems
 

Well House Consultants
You are on the site of Well House Consultants who provide Open Source Training Courses and business hotel accommodation. You are welcome to browse and use our resources subject to our copyright statement and to add in links from your pages to ours.
Other subject areas - resources
Java Resources
Well House Manor Resources
Perl Resources
Python Resources
PHP Resources
Object Orientation and General topics
MySQL Resources
Linux / LAMP / Tomcat Resources
Well House Consultants Resources
Extras Resources
C and C++ Resources
Ruby Resources
Tcl/Tk Resources
Web and Intranet Resources
MySQL module S200
SQLite
Exercises, examples and other material relating to training module S200. This module is presented on Private Courses and Specially Run Courses only

Background
SQLite is a database that's well suited for smaller volume applications as it embeds within the application rather than running as a separate server. Cleverly written, it overcomes the issues which have previously pushed even quite limited applications into using a client / server model. And it's built in to many of the products that we teach, so it's likely there and ready for your use.
Articles and tips on this subjectupdated
4024SQL databases from Python - an SQLite example
There's a new example of relational database use in Python [here] on our site - from the Python course I ran last week. If you cut and paste the script onto your system, it should run with little fuss (and without needing a separate database engine) as it uses sqlite - the built in SQL database - as ...
2013-03-02
 
4007Which database should I use? MySQL v SQLite
Which SQL Database would I advise newcomers with a new application to use? Five years ago, MySQL would have been the obvious choice in many circumstances. But these days, MySQL has grown into a much bigger product and there are very serious licensing and other commercial issues that need to be considered; ...
2013-02-16
 
4006Ruby / SQLite3 example program, showing JOIN v LEFT JOIN
Ruby includes support for the SQLite3 database ... and SQLite is an excellent tool for developing and testing ("Spike solutions") your database structure and concepts before implementing a larger system. For a smaller and straightforward requirement, SQLite may be all that you require. Towards the ...
2013-02-16
 
3269Files or Databases? MySQL, SQLite, or Oracle?
Are plain files a bad idea? Should you use a database instead? Plain text files are a great way of saving data in some circumstances ... but in other circumstances they have "issues": 1. If you're saving columns of data in a plain text file, you need to have some sort of separator between the columns, ...
2011-04-29
(longer)
3139Steering our Python courses towards wxPython, SQLite and Django
With our modular courses that we write ourselves, we've well placed to move forward with technology; more often than not, what's needed is a series of gentle changes, adding in the occasional module for private courses where a particular new subject is needed, with it being introduced into public courses ...
2011-01-21
 
3099Perl - database access - DBD, DBI and DBIx modules
Perl's DBI module provides an excellent link from SQL databases to Perl, and the assorted DBD modules that fit underneath it allow it to operate well for a whole lot of different databases. But they are only excellent as far as they go - for the SQL statements have to be generated in your application ...
2010-12-24
 
2786Factory methods and SqLite in use in a Python teaching example
I've just uploaded a neat little example - [here] from last week's Python course - it's amazing what you can do in a very few lines of code. The application scenario is that we have a database of customers - some are residents at our hotel and others are delegates on our courses. Being mercenary folks, ...
2010-06-02
 
2744PyQt (Python and Qt) and wxPython - GUI comparison
We're running a tailored 3 day Python course at present, using Python 3 if it's practical, and today we compared the two contenders for the "Top GUI" prize - that's Python with Qt (PyQt) and wxPython. Now wxPython isn't yet available in Python 3, but PyQt is - although some of the documentation refers ...
2010-05-06
 
2746Model - View - Controller demo, Sqlite - Python 3 - Qt4
The Model - View - Controller approach to application design keeps the Graphic User Interface (the view) separate from the database (the model), with the controller in between the two, describing how the data is displayed, and how changes to the data are saved away in the database. By separating the ...
2010-04-29
 
2745Connecting Python to sqlite and MySQL databases
For developing a Python application, and for light use, the SQLite database may be a good choice ... but then you may want to be able to expand the system to use a central database with a more classic server such as MySQL at a later date. Using Polymorphism in Python, and with a careful choice of which ...
2010-04-28
 
2561The future of MySQL
MySQL has grown from a very neat little open source database 10 years ago into a very powerful and widespread database that's not always fully open source any longer today. The MySQL company was bought out by Sun a couple of years back (January 2008), and in turn Oracle are now buying Sun. This deal ...
2010-01-03
 
Examples from our training material
seeds.sqlite   SQLite example - table joins
Background information
Some modules are available for download as a sample of our material or under an Open Training Notes License for free download from [here].
Topics covered in this module
Information organisations.
What is a relational database, SQL.
SQL commands, and the SQLite stand alone program
What's different in the SQLite model?
Designing an SQLite database.
Complete learning
If you are looking for a complete course and not just a information on a single subject, visit our Listing and schedule page.

Well House Consultants specialise in training courses in Ruby, Lua, Python, Perl, PHP, and MySQL. We run Private Courses throughout the UK (and beyond for longer courses), and Public Courses at our training centre in Melksham, Wiltshire, England. It's surprisingly cost effective to come on our public courses - even if you live in a different country or continent to us.

We have a technical library of over 700 books on the subjects on which we teach. These books are available for reference at our training centre.


You can Add a comment or ranking to this page

© WELL HOUSE CONSULTANTS LTD., 2018: Well House Manor • 48 Spa Road • Melksham, Wiltshire • United Kingdom • SN12 7NY
PH: 01225 708225 • FAX: 01225 793803 • EMAIL: info@wellho.net • WEB: http://www.wellho.net • SKYPE: wellho

PAGE: http://www.wellho.net/resources/S200.html • PAGE BUILT: Mon Feb 8 18:55:24 2016 • BUILD SYSTEM: WomanWithCat