We will be undergoing scheduled maintenance on May 20th, 2013 at 02:00 GMT.
Real Studio Tutorials
Creating the Database / About SQLite
Visitors to VTC.com will be able to view all introductory videos for each training course.
Free Trial Members will gain access to first three chapters for each training course.
Full Access Members have full access to VTC.com�s entire library of video tutorials.
Learn More
Subtitles of the Movie (Real Studio / Creating the Database / About SQLite)
Now we will begin working on the database that will store our tasks for our ToDo list. The database we will be using is called SQLite. SQLite is a public domain open source embedded database engine, it is used by a wide variety of software and applications, including MAC OS X itself, Adobe Air, Google Gears, Bento, Firefox, and many more. And of course SQLite is also used by REAL Studio where it is accessible via the REAL SQL database class. SQLite is a small fast and very easy to use database. It is ideally suited for desktop applications and works wonderfully with REAL Studio. SQLite is a fully relational database with standard features, such as tables and columns, indexing, views, triggers, and foreign keys. SQLite is not without its limitations, a few of them include, it's rather unusual data type system. With SQLite you can actually store data of any type in a column, without an error, SQLite refers to this as manifest typing, and it's types are referred to as affinities. As an example, if you have a column of type integer, and you attempt to insert a string into it, most database engines would report an error. SQLite will insert the string happily for you. Only four of these affinity types are available, integer, text, real and none. Anything else you enter as a column type is converted to one of these affinities, and remember even if you use one of these affinities as your column type, that does not prevent you from storing data of a different type in that column. Lastly one of the weaknesses of SQLite is that some of it's SQL commands and constructs are not supported. For example you cannot easily remove a column from a table after it has been created. For more information about SQLite, I encourage you to visit the website at SQLite.org. There you will find lots of information and documentation. Additionally there is a great book called the Definitive Guide to SQLite, by APress which I also highly recommend.
Tutorial Information
| Course: | Real Studio |
| Author: | Paul Lefebvre |
| SKU: | 34190 |
| ISBN: | 1-936334-77-1 |
| Release Date: | 2011-02-02 |
| Duration: | 7 hrs / 87 lessons |
| Work Files: |
Yes |
| Captions: | No |
| Compatibility: |
Vista/XP/2000, OS X, Linux QuickTime 7, Flash 8 |
VTC Sign up & Benefits
- Unlimited Access
- 81,350 Video Tutorials (14,200 free)
- Video Available as Flash or QuickTime
- Over 715 Courses
- $30 for One Month Access
- Multi-User Discounts Available
