I am using php and mysql. I have a Database config file (db-config.php) which has my database name, username and password. My application and db config file store at: www(httpdocs)/app/db-config.php Is that secure? Will others/hackers able to steal my file and get my database login information? Or should i put it outside www folder, fo...
According to the .NET framework design guidelines, they say DB is an acronym and cased as such. But I thought it was an abbreviation of database? ...
We have such a oracle database which contains "Tranditional Chinese" character and english, and the environment is : PARAMETER VALUE NLS_LANGUAGE AMERICAN NLS_TERRITORY AMERICA NLS_CURRENCY $ NLS_ISO_CURRENCY AMERICA NLS_NUMERIC_CHARACTERS ., NLS_CHARACTERSET WE8PC850 NLS_CALENDAR GREGORIAN NLS_DATE_FORMAT DD-MON-RR ...
I have a little application written in php+mysql I want to port to AppEngine, but I just can't find the way to port my mysql data to the datastore. How am I supposed to save the data into my datastore? Is that even possible? I can only see documentation for persistence of Java objects, does that mean I have to port my database to a bunc...
I have a set of records, stored as XML files, where the XML files are arranged in a tree structure. For each child record, elements or attributes which are not explicitly stated are assumed to be inherited from the parent record. This is easy to model in a database, with a self-referential foreign key, e.g. Tree Structure Foo / ...
Hello, I was searching for a plugin/gem solution to extend the native rails i18n for storing my translations into my database. Maybe I used the wrong search terms, but all I found was the information, that changing the backend IS actually possible and this blog entry which descripes how to write my own backend. It's hard to imagine, th...
I have two sqlite windows clients concurrently using a sqlite 3 base on the network. When one appends data the record is successfully appended (there's no the journal file at the moment). But another client doesn't see this record even when a fresh SELECT query is fired and starts to see this record of this table after some SELECT querie...
I need to write a query that increments a value in a table by 3 when run. I would like to do something like this but this doesn't work. UPDATE table SET value = (SELECT value FROM table WHERE condition = true) + 3 WHERE condition = true As in the title this is a DB2 database, any ideas? EDIT: Actually this d...
When you save your images (supose you have lots of them) do you store then as blobs in your Database, or as files? Why? Duplicate of: http://stackoverflow.com/questions/3748/storing-images-in-db-yea-or-nay ...
Let's say I have two simple models project t.string :title vote t.references :project t.integer :value When I do loop throuh all projects, I also want to include sum of all votes, because doing projects = Project.all foreach project in projects sum = project.votes.sum(:value) ... isn't really effective. Is there...
Let's say I have something like this: $db=new PDO($dsn); $statement=$db->query('Select * from foo'); while ($result=$statement->fetch()) { //do something with $result } How would I put another query inside of that while loop? Even if I make a new PDOStatement object, it seems that that overwrites the cursor for the topmost PDO s...
i need to import a mysql file into my access db. how do i do this? here's a sample of the mysql file: * MySQL Data Transfer Source Host: 10.0.0.5 Source Database: jnetdata Target Host: 10.0.0.5 Target Database: jnetdata Date: 5/26/2009 12:27:33 PM */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for chav...
I have a CMS that has two menthods to query contents. One that queries by id and another one queries by the name of the content. ContentManager.Select(12); or ContentManager.Select("Content Name"); The way I see the first one would be faster, because the id is an index and doesn't invlove string comparison. While the second one is ...
I accidentaly created a table in PostgreSQL which contains, in its name, some double quotes. I used SQL Server 2000 DTS to import data from it to my PostgreSQL server, but while importing, it created the table but with double quotes in it. Actually the table name when I do SELECT * FROM pg_tables is : public","t_freemailer So, when I t...
I have two MS SQL 2005 servers, one for production and one for test and both have a Recovery Model of Full. I restore a backup of the production database to the test server and then have users make changes. I want to be able to: Roll back all the changes made to the test SQL server Apply all the transactions that have occurred on the ...
Why are relation databases more common than object-oriented databases? If the Object Oriented Programming paradigm is so widespread, shouldn't we see lots of OODBMS? Wouldn't they perform better than the RDBMS+OR/M? ...
How can I handle an array in a prepared statement? i.e, I want to do a query and one of the parameters I get is an array of strings which I want to use in the query (Don't select rows that have a field that's in the array)? ...
I'm from an clientside language programming background, specifically ActionScript. So although I'm fairly code aware I have very little server side experience, particularly version control of databases along with the rails application itself. And then there's the command line which is a complete mystery. Right now I'm building my first ...
I have been using SQL Compare by Redgate at my company and was very satisfied with it. Are there any free comparison tools that are similar? Or what would be my best shot for synchronizing two SQL db's without a paid application ...
What is a search-friendly way to store checkbox values in the database? Currently, checkboxes are processed as an array and values are separated by a ";" As such: <input type="checkbox" name="frequency[]" value="Daily"/> Daily <input type="checkbox" name="frequency[]" value="Weekly"/> Weekly <input type="checkbox" name="frequency[]" v...