I'm using sqlite for the persistent store, so could I just upload the .sqlite file to, for example, Amazon S3 as a way of providing users with the ability to backup their app data?
Then for restoring just download it back and replace the existing .sqlite file in the app's folder.
Does anybody see any issues with that? Has anyone done it? Any other suggestions on how to implement data backup feature?
We're a .NET team which uses the Oracle DB for a lot of reasons that I won't get into. But deployment has been a bitch. We are manually keeping track of all the changes to the schema in each version, by keeping a record of all the scripts that we run during development.
Now, if a developer forgets to check-in his script to the source control after he ran it - which is not that rare - at the end of the iteration we get a great big headache.
I hear that SQL Compare by Red-Gate might solve these kind of issues, but it only has SQL Server support. Anybody knows of a similar tool for Oracle? I've been unable to find one.
Hi,
Can anybody detail some approach on how to save private data in social websites like facebook, etc. They cant save all the updates and friends list in clear text format because of privacy issues. So how do they actually save it?
Hashing all the data with user password so that only a valid session view it is one possibility. But I think there are some problem with this approach and there must be some better solution.
what data type shld i use for data that can be very short, eg. html link (think twitter), or very long eg. html blog post (think wordpress)
i am thinking if i use varchar(4000), it maybe too short for a html formated blog entry? but if i use text, it will take up more space and is less efficient?
I have a data Table with numbers formatted according to the current regional settings. ie ( in French decimal separators are ',' instead of '.' in English). I need to export it to XML. Numbers in XML needs to be formatted according to the current regional settings.But now numbers in XML are formatted in English.Is there any way to make the number formatting in XML according to current regional settings ( or based on the locale of the Data Table) during the exporting process ?
I was trying to use the SessionCustomizer for auditing with v$session.program for oracle and it works with JDBC but i need it working with JPA, so i read a bit more the documentation for SESSION_CUSTOMIZER in this site: http://wiki.eclipse.org/Using_EclipseLink_JPA_Extensions_(ELUG)#EclipseLink_JPA_Persistence_Unit_Properties_for_Customization_and_Validation
but had not lucky in making it work in passing the program name parameter to oracle with the v$session.program... i was using the SessionCustomizer and it is an interface so my code is as follows:
package com.util;
import org.eclipse.persistence.config.SessionCustomizer;
import org.eclipse.persistence.sessions.Session;
/**
*
* @author xkalibur
*/
public class ProgramCustomizer implements SessionCustomizer{
public void customize(Session s) throws Exception {
s.getDatasourceLogin().setProperty("v$session.program","Customers");
}
}
then in CustomerFacade :
ProgramCustomizer pc=new ProgramCustomizer();
public void edit(Customer customer) {
emProperties.put(PersistenceUnitProperties.SESSION_CUSTOMIZER,pc);
em=factory.createEntityManager(emProperties);
em.merge(customer);
}
and returns the following error:
javax.ejb.EJBException
Caused by: java.lang.NullPointerException
at com.facades.CustomerFacade.edit(CustomerFacade.java:48)
please some help...
Hello all, complete newbie here,
I need to find a way to store 250 KB of plain text numbers inside my program's executable file.
Usually, I would put the data in a separate file and let the program read it while it is running, but that's not an option here. Instead, the program and the data need to be in one executable file.
I have absolutely no idea how to do it (except writing 250.000 #defines :-) and I'd appreciate any suggestions.
Thank you very much!
E.g. what "Use Core Data for storage" checkbox option means when creating new Window or Navigation based project?
How to add Core Data for Tab Bar Application?
How to initialize managedObjectModel, managedObjectContext, persistentStoreCoordinator?
I have tried the merge function to merge two csv files that I imported. They both have the same variable names and data types but each time I run merge all that I get is an object that contains the names of the two data frames. I have tried the following:
# ex1
obj <- merge(obj1, obj2, by=obj)
# ex2
obj <- merge(obj1, obj2, all)
and several other iterations of the above.
Is merge the correct function?
If so, what am I doing wrong?
Hi Masters,
Good Day,
I am new and very naive to Oracle DB.
I am using Oracle 10G.
Let me explain to you. I have one source database named ( DB1) and Target Database named (DB2).
I have 2 schema's named dbs1 and dbs2 in the source database (DB1).
I have exported both the database schemas in Source Database (DB1) and imported it successfully into the Target Database (DB2).
Now I face a challenge in synchronizing these database schemas every time from Source DB (DB1) to Target DB (DB2).
Can anyone please help in letting me know how can achieve this synchronization?
It would a great help.
Thanks
Nash
How do I create an instance of a "labelled fields data type"?
data InputData = InputData { events :: [Event], newResources :: [Resource] }
myInputData :: InputData
myInputData = ???
Does anybody else have this same problem, when you import data from Excel file to MSSQL Server 2005, if some column contains mostly numeric data, but even if you set the column type to varchar, the wizard fails to import those fields that fail to parse as numbers?
I plan to use java.util.zip to compress http post data when sending it from a java client to the server(java servlet in this case).
is this the best approach for reducing data load?
should I use gzip as the compression alg?
Hey people!
I guess you people know more about this, than the ServerFault-Peps - If I'm wrong please correct me!
Maybe you experienced it with the Oracle-Databasesystem too that it could use a hell of processorcapacity but it just takes something arround 10% so the processor is bored and your procedures are as fast as a snail in the desert. Do you know any way to say to the system something like: "Hey! You got a lot of power little database-jedi, so use it!"
Thanks for your time and burned out braincells to answer this one!
Greetz from Germany
P.S.:I'm using Oracle 11gR1 here!
In my last question i asked how to best send a string from one view controller to another, both which were on a navigation stack:
http://stackoverflow.com/questions/2898860/pass-string-from-tableviewcontroller-to-viewcontroller-in-navigation-stack
However I just realised I can either pass the path to the file in the app's document's folder as the first (the table view) has already accessed the data in the file should I pass viewcontroller the data to the pushed VC?
I am writing an application that needs to read a data field on another Delphi program and I do not have access to the source code of the 3rd party program. The data field contains the "foreign key" to a record I need to retrieve or create in my application.
I would appreciate any links to knowledge or components that will help me with my program.
I work for a transit agency and I have large amounts of data (mostly times), and I need a way to filter the data using two textboxes (To and From).
I found jQuery quick search, but it seems to only work with one textbox.
If anyone has any ideas via jQuery or some other client side library, that would be fantastic.
Another newbie question: What's the best way to store data in a Cocoa application written in Obj-C? For example if I want to create a sort of "quizzer" that quizzes the user with pre-written (and user-written) questions? How would I store these questions and answers? Core Data?
Thanks!
Is it possible to create collision free hash function for a data structure with specific properties.
The datastructure is int[][][]
It contains no duplicates
The range of integers that are contained in it is defined. Let's say it's 0..1000, the maximal integer is definitely not greater than 10000.
Big problem is that this hash function should also be very fast.
Is there a way to create such a hash function? Maybe at run time depending on the integer range?