Videos in category SQLite
Behind Crate is the idea that a standalone ruby application can be formed into a simple installable application to just drop on a machine and run. An existing ruby interpreter is not required. A Crate application is a custom, static build of the ruby interpreter and all dependent binary extensions required for your application. Your application's ruby code, the ruby standard library and all dep...
Writing iPhone App Episode 5: Persisting Data and Reordering Table Rows
When you quit an iPhone application and restart it later, you want important data to be preserved. In this episode, we’ll save our recipes and their ingredients in a SQLite database. Then we’ll add the ability to reorder ingredients and save their order back to the database. You’ll learn about: creating a SQLite database persisting data to a SQLite database using basic SQL sta...
Creating Offline Web Applications Within The Browser
This is a video lecture on creating offline web applications. It goes into detail on how to create these applications using the Dojo Offline Toolkit, an open source library that makes it easy to create offline web apps.
Installing SQLite 3 on Windows for use in Ruby on Rails
Installing SQLite 3 on Windows is pretty easy, once you figure out what you need to do. But when I started using Ruby on Rails I struggled to figure out what I needed to do. Here's a short screencast that demonstrates how you can install SQLite 3 on Windows so you can use it in your Ruby on Rails applications.
An Introduction to SQLite
Google TechTalks May 31, 2006 Richard Hipp ABSTRACT SQLite is a small C library that implements a self-contained, embeddable, zero-configuration SQL database engine. SQLite implements a large subset of SQL-92 and stores a complete database in a single disk file. The library footprint is less than 250 KB making is suitable for use in embedded devices and applications where memory space is scarce...