Hello all, I save a file with part of the filename as the session_id using PHP, like this: $newFileName = 'upload_160687_'.session_id().'_160687_'.$originalFileName; I then save the filename as a string using PHP in the DB and it looks like this: upload_160687_l4eef6nqlekhbirv2pvmuf5660_160687_Apple_Microsoft_desktop1-1.jpg Howeve...
I have a website that I've integrated with a popular forum software (phpBB). I have it setup so users that login to the main site automatically are logged in to the forum software as well. I do this by authenticating through the forum's API at the very same time. When someone registers for the site, an entry goes in to the main site dat...
I have posted a question about database selection for small projects, but no one selected or mentioned Blackfish. I am using it for a while and I like it, to some point better than SQLserver. Id like to know other experiences with it, problems, limitations, tools to manage it being built. ...
I recently upgraded my server running CentOS 5.0 to a quad-core CPU from a dual-core CPU. Do I need a recompile to make use of the added cores? PostgreSQL was installed by compiling from source. EDIT: The upgrade was from an Intel Xeon 5130 to an Intel Xeon 5345. ...
Has anyone tried to dynamically select which properties they want to write to an entity on appengine? For example: I have a web form with 5 fields, and any given user will fill out some subset of those fields. I POST only the fields with data to the server (e.g. Fields 1,2,4). On the server side, how do I elegantly write only properties...
i have in the database typical tables like user, usergroup, and they have relations. in my domain-model i want that if you request users, you will get the users and each user has the property belongsto, which means these are the groups he belongs to. in the property i want to have the list of groups (typesafe as groups) the same should...
Just listening to this week's podcast and thought it would be nice to group together some of your experiences where you've seen the "architecture" side of design dominate things a little more than it should. Java often gets a bad press in this respect, and an increasingly bad press as the perceived complexity of JEE increases. My Java e...
When I want to design database tables that model a finite parent-child relationship, for e.g., computer as parent, and the components inside as the child; or a simple organizational hierarchy, I am usually torn at which approach to use - A 'specialized table' approach, in which I create a table for each of the possible entity. In the ...
Hi guys, I own a website with 20 GB data on it Now I decided to change the Hosting compnay . I'm Moving to Russian VPS so is there a way to transfer the contents of my website to the Russian VPS without uploading them again . Is there a service that does this. I heard that there is a way to do this using shell access (BUT what is shell ...
Hi all, Hopefully someone can shed a little light on an issue that I'm currently having with an Oracle DB - I'm sure it's something simple!! I've managed to recreate this in a sample, so here is the DB structure: CREATE TABLE MyTable( ixMyTable NUMBER, clobData CLOB ) / CREATE OR REPLACE PACKAGE PKGTEST AS PROCEDURE DoSo...
I have a SQL table like so: Update: I'm changing the example table as the existing hierarchical nature of the original data (State, Cities, Schools) is overshadowing the fact that a simple relationship is needed between the items. entities id name 1 Apple 2 Orange 3 Banana ...
As a computer software expert witness, I am required to analyze a huge range of different software technologies. During my deposition or trial testimony, the opposing expert may direct questions targeted at exposing or revealing my weaknesses. There is no time for research or education. Given that I can't be an expert in every techno...
Hi! Let's say I have the following model: class Contest: title = models.CharField( max_length = 200 ) description = models.TextField() class Image: title = models.CharField( max_length = 200 ) description = models.TextField() contest = models.ForeignKey( Contest ) user = models.ForeignKey( User ) def score...
Im trying to create this: Tag1 has the erdered list of objects O1, O3, O2 Tag2 has the erdered list of objects O1, O4 Every time I click a tag, I want to see the list of objects. So clicking Tag1 would show in a listbox: O1 O3 O2 But I would like to keep the auto update so every time I edit or add/delete an object it auto updates (...
I am a PHP programmer and I want to develop a website using visual web developer .net I knew that asp.net has many different approaches in dealing with database. However, I am familer with PHP way in programming for example: $query = "select * from table where user_id > 2" $result = mysql_query($query); while($row = mysql_fetch_array($...
Hai Techies, I have some stored procedure which was written in SQL server.Now i want to migrate this to mysql.Is there any freeware tools which can do this for me. ...
In my application I have different categories that users can post their transactions as. Example: Food, Shopping, Movies, etc.. I want the user to be able to edit these categories and add/remove categories. What is the best way to store this information in a database. A categories table with the category and corresponding user? Then I ...
I have many tables in my database which are interrelated. I have a table (table one) which has had data inserted and the id auto increments. Once that row has an ID i want to insert this into a table (table three) with another set of ID's which comes from a form(this data will also be going into a table, so it could from from that table)...
Is it possible to open a .mdf database file created in Visual Studio with some external SQL server IDE like Quest Toad for SQL server? Databases created in Visual Studio are rather similar to simple Access databases in that they're a single file. It appears external IDE's like Toad can't see the .mdf being served by my localhost's SQL ...
Let's say I have a fairly simple app that lets users store information on DVDs they own (title, actors, year, description, etc.) and I want to allow users to search their collection by any of these fields (e.g. "Keanu Reeves" or "The Matrix" would be valid search queries). What's the advantage of going with SQL full text search vs simpl...