CODEWITHSUNDEEP
androiddatabasesqlitedatabase-design
Saro Taşciyan
Saro Taşciyan

Reputation: 5236

Advantage of creating separate databases for each table in SQLite (Android)

I saw a couple android applications (popular applications like Facebook and Google Play Store) with separate databases for each table created in design and i wonder why has it been done. What is the advantage of creating a new database for every table in SQLite ? Any ideas ?

Upvotes: 1

Views: 452

Answers (1)

Jim
Jim

Reputation: 10288

In the question's comments, FB and Google Play are mentioned. If you are building enterprise level code that may have patterns, objects or recycled code, then maybe using multiple databases is easier than re-engineering complex systems like that.

One other reason, similar, is that you may be merging two dissimilar systems into a single app and the database schemas have conflicting table names, stored procedures, etc. So, complexity alone would not determine it, but porting existing systems without redesigning or engineering them might result in this.

Last, having multiple teams develop different aspects of a complex app might - but most likely the DB engineers would hash out their differences rather than build multiple databases.

Upvotes: 2

Related Questions