HTML5 Local Database Find if Database Table Exists

Question

Every time a user comes to my page, a couple of local database tables are CREATED IF NOT EXISTS. Then the records for these tables are queried from the Actual Database and inserted into the local database.

Is there a way to tell if a table has "Just been created" or if it "Already existed", so I do not have to call the "Actual Database" and prevent getting duplicate records?

Thanks!

I'm not sure I understand the difference between "local database" and "actual database". What type of SQL are you using - TSQL? Why are you creating an extra database if a database with relevant data already exists? — Snuffleupagus
– Snuffleupagus, Commented Mar 13, 2012 at 20:01
That's a good question. I'm using a Local Database (similar to this html5 ex: blog.darkcrimson.com/2010/05/local-databases). I also have a database in the back end, which holds all the data. My goal is to populate the local database with data from the actual database. This way the user has access to data that exists in the actual database and can still interact with the page. — Garrett
– Garrett, Commented Mar 13, 2012 at 20:27
My question is that is there a built-in or easy way to find if a table already Exists or if it has Just been Created. Knowing this definitely reduces the transfer of Request/Response data. I'm thinking about selecting to see if a table exists, but I'm not sure that would be the best idea. Is there some type of built in function to check whether a table exists? — Garrett
– Garrett, Commented Mar 13, 2012 at 20:30

Jacob Lukas · Accepted Answer · 2012-03-13 20:34:04Z

1

You could count the number of rows in your local database. If the number is zero, then it's likely the table was just created.

Alternatively, if you have a strictly-increasing column, you could ask for the largest value. If no value returns, ask the server for all the rows. If a value is returned, ask the server for all rows greater than the value. This would keep your local database in sync with your "actual" database.

answered Mar 13, 2012 at 20:34

Jacob Lukas

6976 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

HTML5 Local Database Find if Database Table Exists

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related