Can I access android MediaProvider (Images & Videos) databases directly from my code rather then through a content provider ? I'm planning to have my own Cursor implementation so inside it I want to access the media databases directly, possible or android does not allow it ? ...
Hello, I have a few general questions about database Index. Answers to any question are awaited: How to calculate total memory size occupied by an index. And is the size of index directly proportional to its Cardinality ? Do we need to index primary key, or is it indexed by its own. And how will it effect the memory and processing spe...
Is it possible, and if so how can I effectively sync a local database with a global one such that when an action is taken on the local version it is also made on the global database. Simply using version control to subvert the global is unacceptable because there could be several local copies of the database according to the number of p...
I have a table of Users (tblUsers) which contains details of University staff. I am trying to populate a text box with the names of lecturers associated with a selected module. I am getting all UserIDs associated with a particular module, testing if the User is a lecturer, if so then I add the ID to an ArrayList. I then iterate throu...
I'm looking for a best practice / thoughts on if it is better to do a select count and checking if the result is > 0 before calling a delete or if it would be better to just blindly fire a delete statement at the database even if the data doesn't exist. In our case most of the time data will NOT exist. So what is better: Option 1: c...
i am using a simple database design and i think the best database example is e-commerce, because it does have a lot of problems, and its familiar to cms. USERS TABLE UID |int | PK NN UN AI username |varchar(45) | UQ INDEX password |varchar(100) | 100 varchar for $6$rounds=5000$ cr...
Some time ago my company was evaluating different reporting solutions. We settled on MS SSRS particularly because it's capable of connecting to various types of data stores, including MS SQL, Oracle and SAP Netweaver BI. It has proven the test of time pretty well, however, we're now under fire from management because SSRS is not capable ...
Which is more expensive to do in terms of resources and efficiency, File read/write operation or Database Read/Write operation ...
what to use for database , while developing J2ME apps ? I mean should I use simply txt files or some database like sql is available in mobile phones ? ...
I was a MySQL user. Now I'm migrating to SQL Server. But I have a problem. I can not find any way for specifiying the kind of index a table has. In MySQL I could easily say to build a BTree Index or Hash Index. How can I do that here? The main problem is that I have two tables. one of them (named "posts") has a foreign key to the other ...
First i was using this request: Model.object.get(name='somethink', date=somedatavariable) But then I needed to extend my query and change it to this: Model.objects.get(name__icontains="somethink", date__range(start_date,end_date)) Suddenly my database takes 5 times longer than with the original query. What's going on here, and how ...
If I have a relationship between two tables (both tables have their own primary keys) what should guide my decision as to which table should store the foreign key? I understand that the nature of the relationship probably matters (one-to-one, one-to-many, many-to-many, uni-directional, bi-directional), and probably access patterns matter...
I have the following database table with information about people, diseases, and drugs: PERSON_T DISEASE_T DRUG_T ========= ========== ======== PERSON_ID DISEASE_ID DRUG_ID GENDER PERSON_ID PERSON_ID NAME DISEASE_ST...
I have a Django app that opens a file, continuously reads it, and at the same time writes data to a Postgres database. My issue is that whenever I open a file, file = open(filename, 'r') I am unable to also create new things in the database, Message.objects.create_message(sys, msg) That should create a database entry with two str...
We're using an Access Database as the back-end to our software product. The program has been alpha/beta tested at a company for about 2 years now and we've noted that one of our tables has been filled with over a hundred thousand records in that time. This is probably not an example of the heaviest usage that our product will endure, an...
I have a large list of strings (1500 email addresses to be more specific) and I need to look up a piece of data in a very large DB table for each of the strings (e.g. the primary key, mydataitem). How can I do it efficiently? For example, this is way too slow (amongst other problems): $stringArray = ('foo','bar','baz',..., 'for 1000s...
I'm trying to code an "undo" or "rollback" type scenario. Part of me thinks I am over complicating this and it must have been solved before. Background: I have a Product (eg A book) the product has 20 fields. A Product has a Media Type (PDF, Hardcopy, EPUB) and each Media Type has multiple pricing (price, location ie Europe, Asia, A...
Basically, I want memcached that can store over 1MB. ...
What is the Best way to kill database Routine(repeated) work in php , i work daily with php & mysql through pdo and other libs , but i feel i repeat myself over and over ADD , DELETE , UPDATE , especially in admin panel , every task require these operations , its kill the programming enjoyment... ...
I would like to store an object that has a name and some attribute and any kind of database and have another that that document relationship between between them Let say this Object A Object B Object C Object D A is related to B A is related to D B is related to C All relation have also attribute that give the relation order (uni (fr...