I have recently agreed to do some minimal editing to a ColdFusion site and was hoping to get some help on here as to where a place to look for db settings may be. I have not been able to locate the database config file or something similar. A point in the right direction as to best practice for ColdFusion would be really helpful or an ...
To migrate my database faster, I tried copying the raw files (MYD and MYI) files of a database into another machine. All the tables are working fine except two tables that were partitioned. My directory structure looks like this: table1.frm table1.MYI table1.MYD table2.frm table2.par table2#P#p0.MYD table2#P#p0.MYI table2#P#p1.MYD tabl...
Hi, I have about 5GB data to store BDB, but I found the performance is not very good. Does it support data partitioning? thanks ...
Hello, I am just wondering about how android handles sms when it receives them. More precisely my question is when the android phone receives a sms message, which application saves the message to the mmssms database? Is this done by the OS or by the native sms application? ...
I have a activity with 3 imagesViews and a Button. Clicking on the ImageView shows an AlertDialog with a list of images (located in /res/drawable) that the user can select. I've hit a wall where I don't know how to store the images to the database that were selected in the ImageViews. Any pointers? ...
Hi, i have this form: wich contains a list of students on the left and a lot of skills to assign to each student. Each student have it´s own table with the full skill list (HTML, CSS, ...). Now whats a simple way to get value from the checkboxes and assign them to the corresponding student table? The purpose is to creating a graph f...
A quick question, Does google app's datastore support foreign key mapping, if yes, can anyone enlightened me XD, or share some link. thank you very much, ...
Hi, I created views in mysql database. Now when i query with them i got error table "view name" is in use. in phpmyadmin it is showing in use where it shows record numbers. I tried repair-table option from PhpMyAdmin tool, but it gives error "it is not a table". i'm not able to take backup of my database. what can i do? ...
I'm writing a game server to which many players connect. I load up the DB into a DataSet(strong typed). Every time a player logs in, I add a new row to Messages table using a TableAdapter. code var newRow = _db.Messages.NewMessagesRow(); // _db is a strong-typed-dataset { newRow.Title = title; new...
I would like to create table to storage short text. What is the best type to use. char varchar but i can't guarantee the text length. Any best practice ? ...
For example: @Table(name = "stock", catalog = "mkyong", uniqueConstraints = { @UniqueConstraint(columnNames = "STOCK_NAME"), @UniqueConstraint(columnNames = "STOCK_CODE") }) or @Column(name = "STOCK_NAME", unique = true, nullable = false, length = 20) Constraints like 'unique', 'nullable', even field length are core database featu...
When parsing and inserting data, I accidentally inserted a string (ip address) into a bigint column in a MySQL table without using the INET_ATON function. Is there any way I can recover the original string? ...
I know it's a bad practice to use database in the view. However, I'm also passing the User object and I wonder how I can make it easy to use. I love the way it works in Ruby On Rails. You just create an @instance_variable in before_filter and call it from the controllers and from the views. You can't do this in ASP.NET MVC though. So I...
According to the App Engine docs, you wrap a datstore event in a transaction like this: import javax.jdo.Transaction; import ClubMembers; // not shown // ... // PersistenceManager pm = ...; Transaction tx = pm.currentTransaction(); try { tx.begin(); ClubMembers members = pm.getObjec...
What's the preferred method to fetch a subset of records from the database? Use rs.absolute() or Limit? ...
I wanna learn more about NoSQL databases by writing an application making heavy, heavy use of simple writes/reads. Could anyone offer some ideas into possible web apps? I had in mind: url shortener canvas based game that tracks keyboard movements autocomplete lookup services chat powered by node.js, chat logging powered by nosql datab...
Is it possible with Kohana v3 Query Builder (Kohana v3 being possibly the most poorly documented #$@$%...) to use the IS NOT NULL operator? The where($column, $op, $value) method requires all three parameters and even if I specify ->where('col', 'IS NOT NULL', '') it builds and invalid query eg. SELECT * FROM table WHERE col IS NOT ...
I'm using Django and MySQL to serve a website. I have my own MySQL server on localhost for my site. Now I have a third-party MySQL database that I need to use to read and write to that is on a remote host. I set up the new database's information in my settings.py file, but a problem occurs when I try to access the remote DB. Because the ...
I am looking for a Java-based implementation of an XML native database, which exploits XML schema to provide strongly typed operations and checks over the stored data. Does anyone is aware of such a database? ...
Table is a Mongoid model that must dinamically map to different databases/tables # app/models/table.rb class Table include Mongoid::Document end # in app/controllers/some_controller.rb def index Table.connection.database = :other_database # <- How to do this ??? Table.table_name = params[:id] # <- How to do this ??? @records...