I understand it is possible to store images in Databases as Binary large objects. But I used to see in some forum web applications that they are stored as flat files in web server machine and retrieved when needed. What is the advantage and disadvantage in both methods? When to go for which approach? ...
Hi, I have installed sqlanywhere11 which inbuilt as ultraLiteJ. I have created an app Using the tutorial Part 1: Creating an UltraLiteJ application on BlackBerry. I have followed all the steps given in the tutorial 1. Create a Workspace. 2. Create a Project in the workspace 3. Add the UltraLiteJ JAR file to the project. 4. Ensured that...
Hi, I'd like to move some small app databases to a cloud hosting provider. Basically, I'd like to not have to manage databases myself. I've been looking at Amazon RDS and MongoHQ, which are great, but are bit expensive. Are there any other alternatives other than setting up my own VPS? Thanks. Jim- ...
I'm using Google Gears to be able to use an application offline (I know Gears is deprecated). The problem I am facing is the synchronization with the database on the server. The specific problem is the primary keys or more exactly, the foreign keys. When sending the information to the server, I could easily ignore the primary keys, and ...
I had a constraint in a table CREATE TABLE "USERSAPPLICATIONS" ( "USERID" NUMBER NOT NULL , "APPLICATIONNAME" VARCHAR2 (30) NOT NULL , CONSTRAINT "PK_USERSAPPLICATIONS" PRIMARY KEY ("USERID","APPLICATIONNAME") ) / Two weeks ago I modified the table, added some columns, deleted the constraint "PK_USERSAPPLICATIONS" and add...
Hi All, I want to create a crystal report application in visual stuio 2008, which will be able to create reports by the user. the user will choose the filed he wants and the report will view them. I also want to know if there is an option to create "smart fileds" which wil calculate for example an input - date and will view the date+ 3...
I think the word "clean" isn't the right idea, but I am trying to make sure that the data I am getting from the database is ready to be inserted into JSON objects. I would like to find a packaged deal for this, or if JSON.Simple does this and I just haven't run into it. But double quotes, single quotes (for obvious reasons), and new line...
I just transferred open x to a new server and need to change the db info (host, username, password, db name). I have been looking over and I can't find a settings, config file. Update: Found config file inside var folder ...
When creating database tables I'm often stumped when trying to name my time/date/timestamp fields. Sometimes it's easy, like edit_date and expiration_date... but often it's not as easy. I don't like repeating the table name in the field names because it seems redundant. If you have a posts table, should your timestamp field be post_date?...
I have a list of product edition serial numbers to store in MongoDB, eg, [{"name": "123 > Item A", "serial_number": "123.1"}, {"name": "123 > Item B", "serial_number": "123.2"}, {"name": "123 > Item C", "serial_number": "123.3"}, {"name": "123 > Item D", "serial_number": "123.4"}, {"name": "124 > Item A", "serial_number": "124.1"}] ...
I have a website that allows users with accounts. Account profiles are displayed on the front end of a website. Users can login and update their data, but it all must be approved by an admin (on a form) before the front end content reflects their update. The "live" data is stored across multiple tables in a Postgresql DB. I'm looking...
Hi, I'm creating a RESTful API which needs to access the database. I'm using Restish, Oracle, and SQLAlchemy. However, I'll try to frame my question as generically as possible, without taking Restish or other web APIs into account. I would like to be able to set a timeout for a connection executing a query. This is to ensure that lo...
I'm looking to attempt to simplify address entry into a system where the city textbox has autosuggest initially populated by the user's geolocation. In the past it has seemed that autosuggesting the city name is prohibitively costly without knowing the province/state/country first but it doesn't make sense to require the user to enter t...
I just read this blog post and, in short, it say that if an SQL server isn't doing a good enough job building query plans, then the last thing you want to do is start hard coding stuff. So, that got me thinking; how could you "hard code" stuff without hard coding stuff. (Yes, that's the way I tend to think.) Is the following; 1) possibl...
I have a table with a primary key that is auto increment. I want to have an image associated with the primary key but I don't want the primary key to be revealed. Would naming the images something like: $filename = md5($primarykey + $secret_string) . '.jpg'; be a good solution? I am worried that there could be a collision and a file ...
It's my first time to use Persistence in developing a Java program because I usually connect via JDBC. I read that for large amounts of data, it is best to use persistence. I tried playing with the CRUD example of Netbeans. It's not very helpful thought because it only connects to the DB and allows addition and deletion of records. I nee...
What would be the code for creating a table with two foreign keys? I have a USER table and a PICTURE table. Since a USER can be in many PICTURE and many PICTURE can be from a USER, I need a third table with both primary keys. Thank you SO, as usual you are invaluable for a learning novice. :) ...
Okay, so I am modeling a Datacenter with an inventory of Parts for replacement of failures inside a Server. (present models italicized). I have an InventoryEntries model because I have a swap model that a datacenter enters on a form to record that a replacement part(cpu,psu,fan,bbwc) has been taken from inventory and placed in a server b...
I have the following code: <?php $code = $_POST['code']; // textbox $con = mysql_connect("***","****","****"); if (!$con) { die('Server overload, please try again' . mysql_error()); } mysql_select_db("example", $con); $sql = mysql_query("SELECT code FROM exampletable"); while ($version = mysql_fetch_array($sql)) { // ...
I have this code wich gets WP posts, but it gets all the posts and orders them from the first to the last. I want only the last 10 post ordered from last to the earlier. What I have to change? Thanks a lot in advance! <?php $dbhost = 'localhost'; $dbuser = 'root'; $dbpass = ''; $conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ('...