Archive

Archive for the ‘Database’ Category

How does a database deal with concurrency?

July 28th, 2011

I’ve always thought about the following scenario:

Person A works with data at the same time as Person B (who is also working with the same data). They both commit at the same time and would have manipulated different elements of the data, so overwriting isn’t the case here.

How would the database deal with this?

admin Database , ,

How do you insert user input into an SQLite Database in Android?

July 26th, 2011

So I’m fairly new to Android programming, and I have an SQL database class set up, and I can add items to it just fine from within its own class. The problem is that I can’t implement a method in my main class to add items to the database, it just crashes the application. How do I access the database from a separate class?
I have tried creating another instance, however since the database class is also an Activity, it crashes the program

admin Database , , , , , ,

Is it possible to use SQL in Excel for data within a spreadsheet?

July 26th, 2011

I know there are plugins that allow you to use SQL to access information from a database, but I would like to use SQL to query data within a spreadsheet.

admin Database , , , ,

How Can I Automatically Backup My MySQL Database Hourly?

July 26th, 2011

Hi! I have a MySQL database that I want to automatically backup to my computer every hour. How can I do this? I’d really prefer a free solution to this. Thank you!

admin Database , , , ,

How can I query an access database for all records not past their expiration date?

July 26th, 2011

I’m not trying to set up a complex database, just trying to set up a household coupon management database. I can’t figure out how to run a query so that it will only show records that are not expired (I have their expiration dates as a field in the original table). Any ideas?

admin Database , , , , , , ,

PostGreSQL-PGAdmin

November 9th, 2010


Aprenda Banco de Dados PostgreSQL neste ótimo curso do Professor Neri Neitzke. Para comprar os cursos acesse www.informaticon.com.br

admin Database