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:

Create your own Meetup Group

Get started Learn more
Bill

I started the group because there wasn't any other type of group like this. I've met some great folks in the group who have become close friends and have also met some amazing business owners.

Bill, started New York City Gay Craft Beer Lovers

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