addressalign-toparrow-leftarrow-rightbackbellblockcalendarcameraccwchatcheckchevron-downchevron-leftchevron-rightchevron-small-downchevron-small-leftchevron-small-rightchevron-small-upchevron-upcircle-with-crosscrosseditemptyheartfacebookfolderfullheartglobegmailgoogleimagesinstagramlinklocation-pinmagnifying-glassmailminusmoremuplabelShape 3 + Rectangle 1outlookpersonplusprice-ribbonImported LayersImported LayersImported Layersshieldstartrashtriangle-downtriangle-uptwitteruseryahoo

Database Introduction with SQLite

Starting at 6:30pm, we'll have free food sponsored by Arbormoon Software, Inc.

Our main meeting will start at 7pm, and feature a Database Introduction with SQLite talk by Dean-O Rochester

Android, Blackberry, iPhone and Palm support using an embedded database known as  SQLite We will go through a basic example that will show you how to integrate an SQLite database into your application.
Things you will need:

  1. SQLite software to create the database
    1. comes standard on intel macs
    2. free needs to be downloaded for windows
  2. SQLite browser/editor software
    1. used to create/edit databases and tables
    2. free needs to be downloaded and set up
  3. Create a simple database and table
  4. Create Android Database sample application
  5. Put database into Android project
  6. Test app (fingers crossed, hope all goes well)  :)

Dean-O is a Programmer Analyst for a health care system in Ohio by day, and after hours he is an independent app developer.  In addition, he is Adjunct Faculty at BGSU and Owens Community College teaching programming related courses including java curriculum and smart phone programming.

Join or login to comment.

  • Dean Rochester call me ".

    Thanks for sharing Scott and others who added info to this topic. Now if I can just see how to post the slides... anyone with a pointer on that, please advise.

    February 28, 2013

  • Scott W.

    Cross-posting from the Google+ page for this event (https://plus.google.com/events/cnppsqvc92c0aofhjsibbutpvas):

    As I mentioned in the meeting tonight, hard-coding the path to your database (or other) files is no longer tenable with multi-user devices in Android 4.2. However, the fix is really very easy. All you need is a reference to a Context.

    So, instead of something like this:
    String dbPath = "/data/data/com.example.mycoolapp/databases/";

    You would have this:
    String dbPath = context.getFilesDir().getAbsolutePath() + "/databases/";

    Nice, easy fix to avoid problems with multi-user devices. Hope this helps!

    February 28, 2013

  • Barbara E.

    Last minute schedule change, so I won't make this one.

    February 28, 2013

  • Geno A.

    Name: Geno Arindaeng
    Company: Techsmith

    February 25, 2013

32 went

Our Sponsors

People in this
Meetup are also in:

Sign up

Meetup members, Log in

By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy