I'm looking for links, or an answer here, on to how to properly configure the database permissions to secure a Django app? To be clear, I'm looking specifically for material dealing with grants on the database, not permissions within the Django framework itself. ...
My Android app is using a database through an API packaged in an external JAR. Since the JAR is opening/updating/closing the SQLite database file, do I need to make sure it uses its own package name instead of my own? Im getting errors where it fails to open the database file and Im guessing its because the package name Im telling it to ...
Hi, iam trying to locate the database files on my nexus device.. is there anyway of doing it without rooting the device? thanks ray. ...
Hi all, I periodically receive data that I use to update my database with. The external structure differs from my internal structure so what I end up doing is running the import and then running alter table commands. I do this manually. After I format it to my liking, I export the data and then import it into my existing schema. My ...
I have used code like this: http://msdn.microsoft.com/en-us/library/dw70f090.aspx to access database before when working in ASP.NET (2-3 years ago). I didn't realize I was working with ADO.NET. I am just a bit confused...is there another way data in a database can be accessed? How else would you do it? ...
I have an instance of Django-CMS already running in a production environment. I would like to dump all the data related to the CMS (PAGES and PLUGINS) so that I may load it back into my development environment. When I do python manage.py dumpdata cms it dumps most of the data, but not all of it. None of the content for the plugins i...
Hi, I have never connect a database in java before. May I know should I go about accessing a derby database with servlet? I have checked out this: How do I access a database from my servlet or JSP? But I saw comments on the article saying that this is a bad way to connect. Could any one explain or show me the best way to that I should ...
i have just finished my first site built with zend framework and all works great on my local machine. then i uploaded it to the server (godaddy) and all works except any connection my models do with the database. i have made a connetion to the database with regular PDO with the credentials in my application.ini and it worked, and i can ...
Hi, I have a sql question on derby database: Select a.name, a.starttime, a.endtime From a How can I add to the above sql statement such that I can get the difference in hours between the start time and end time? (I only know that for mysql there is a DATEDIFF function, but I am not sure about what function should I use for derby db) ...
Is there any way to retreive the result set of a sql query in a local variable; the query is to be run in a batch file. What I am trying to do is something like this: set varname = osql -S%dstserver% -d%dstDB% -Q"SELECT name from table_name where Id = %siteId%" %osqluser% -b varname is my local variable. I am quite new in sql so any ...
I know about OOFNF (object oriented functional normal form) as an equivalence to normalization process in relational databases. Does anybody knows about any other definitions?? Thank you ...
i created the database like this db.execSQL("CREATE TABLE "+TABLE_NAME+" (" +_ID+" INTEGER PRIMARY KEY AUTOINCREMENT," + TITLE+" TEXT UNIQUE," + PUBLISHED+" DATETIME," + CONTENT+" TEXT," + RATERS+" TEXT," + VIEWCOUNT+" TEXT," + THUMBNAIL+" TEXT," + FAVCOUNT+" TEXT," + FAVSTAT+" INTEGER," + LI...
I need to write a Mac Objective-C/Cocoa app that connects to a remote MS SQL Server. How to do it? Also, how to run SELECT/UPDATE/INSERT/DELETE in this connection? ...
Hi, I've got a simple object with three properties. This links to a table with three columns, with two of the columns being primary keys (one int the other a datetime). Whenever I try and query nhibernate I get the following error message: could not resolve property: invdate of:Models.Invoice Have I missed something simple in se...
How does the data in a database in the field get upgraded because a new version of the software is being released? For an example, consider look up data. Usually the look up data associates an ID (number) to a name (string) and then this ID is referenced in other tables instead of the the ID directly (i.e. normalized). There are other ty...
So my Passenger spins up 5 instances of my Rails app I connect to MongoDB using Connection.new("localhost", 3000, :pool_size => 1, :timeout => 5) Why would I need a "pool of connections" if I only incur overhead when starting up my Rails app, not per request? Why would a single process need more than 1 connection? And what is the ...
Hello, I'm not a SQL Expert. I'm using SQL Server 2005 and I'm trying to figure out how to structure a query so that it can meet several requirements. I have two tables defined as follows: Classroom - ID - DepartmentID - TeacherName - RoomNumber Student - ID - Name - ClassroomID I'm trying to build a query that says, "give me...
ok lets assume i have a table now it has only two rows in it and i dont want anyone to add any more rows to it? it can be accessed by c sharp but it should not be openable using SQLite admin or any other db manager , is that possible?? I dont want the user to add another row outside c sharp can this be done???? triggers??? ...
I have two very large tables and I need to process a small resultset from these tables. However, processing is done in several functions each and function must do some joining in order to format the data in proper way. I would definitely need to cache the initial resultset somehow so it can be reused by the functions. What I would like ...
Here is my schema: Suppliers(sid: integer, sname: string, address string) Parts(pid: integer, pname: string, color: string) Catalog(sid: integer, pid: integer, cost: real) Primary keys in bold. Here is the MySQL query I'm working with: -- Find the sids of suppliers who supply every red part or supply every green part. -- this isn't...