Hey everyone, Sorry in advance for the kind of odd/vague question :). I've come across this kind of formatting stored in MySQL databases on several occasions now and I'm wondering how the data is used? For example, this line of code was from the bbPress forums plugin bb_message. a:8:{s:9:"max_inbox";i:50;s:13:"auto_add_link";b:1;s:9...
This may be something totally simple, but I can't for the life of me get this working. For some reason, :autosave isn't actually autosaving underlying models. Here is my schema: create_table :albums do |t| t.string :title t.text :review t.timestamps end create_table :songs do |t| t.integer :album_id t.string :name ...
For a clean data model, I'm going back and forth on this... Using an approval workflow as an example, let's say in my web application I have a page that lets a user flag a MyEntityObject for approval. MyEntityObject has a few properties that control its approval workflow, so I have a common utility method out there called FlagForApprova...
I have an application that requires analytics for different level of aggregation, and that's the OLAP workload. I want to update my database pretty frequently as well. e.g., here is what my update looks like (schema looks like: time, dest, source ip, browser -> visits) (15:00-1-2-2010, www.stackoverflow.com, 128.19.1.1, safari) --> 10...
Howdy, Last year we launched http://tweetMp.org.au - a site dedicated to Australian politics and twitter. Late last year our politician schema needed to be adjusted because some politicians retired and new politicians came in. Changing our db required manual (SQL) change, so I was considering implementing a CMS for our admins to make...
I'm building an application and need a data structure of interconnected objects that can be queried and traversed. The connections between objects can be arbitrary and not necessarily known before hand. I need this data structure to be queryable (what usual SQL provides) and also traversable (what new graph database like neo4j provide)...
Dear All, By having the next dsn file: [ODBC] DBQ=C:\\SLA.mdb C:\\SLA.mdb DefaultDir=C:\ Driver={Driver do Microsoft Access (*.mdb)} DriverId = 25 FIL=MS Access MaxBufferSize = 2048 MaxScanRows = 8 PageTimeout = 5 SafeTransactions = 0 Threads = 3 UserCommitSync = Yes [Microsoft Office] DefaultTable =table1 how could I edit it to have ...
I've got two tables from which I need to extract information, but the data from the second table depends on the information I get from the first one. Is there an easy way to handle this? <?php mysql_connect('localhost', 'root', 'root') or die(mysql_error()); mysql_select_db('stadium') or die(mysql_error()); $result = mysql_query(...
Hi friends, I have to create a database with three tables one for country then State and cities My Country table is ok. But i want to include all states of america to my state table and all major cities of each state in america to my city table. i want any such database so that i can import my database i need only major cities. is...
I recently joined a new company and the development team was in the progress of a project to rebuild the database categories structure as follows: if we have category and subcategory for items, like food category and italian food category in food category. They were building a table for each category, instead of having one table and a l...
Today I've implemented a nasty hack in my code where every request to the database opens it's own connection due to the fact that I couldn't find any way to enable MARS (multiple active record sets) when communicating with a MySQL database. In my C# program I do a lot of parallel work, which isn't a problem regarding databases such as M...
Hi I'd like to access an Internet database from my app to edit it and read it. Any link I should read or any advise? Thanks ...
Is it possible to develop multi-client web-based CRUD applications (with Django, Ruby on Rails, etc.) on a server on which you don't have root access? Our machines at school, on which I have a regular account, run a web server, and I can publish regular HTML pages and CGI scripts. How easy/difficult/impossible would it be to install Dja...
Hello, Let's say my application creates, stores and retrieves a very large amount of entries (tens of millions). Each entry has variable number of different data (for example, some entries have only a few bytes such as ID/title, while some may have megabytes of supplementary data). Basic structure of each entry is same and is in XML for...
I have a table which contains ratings. Included with the rating is data the user provided such as the language that the linked series belongs to. id series_id language quality type rating 1 18 1 2 1 20 2 18 2 3 2 13 3 18 1 1 2 25 4 18 1...
If you have to use PostgreSQL instead of Oracle or DB2, what feature would you miss the most? I'm specially interested in features which are important for high availability OLTP applications. Thanks! Edit: I'm looking more into technical limitations. Let's assume you have the same level of expertise in PostgreSQL, Oracle and DB2. ...
I'm developping a web application using google appengine and django, but I think my problem is more general. The users have the possibility to create tables, look: tables are not represented as TABLES in the database. I give you an example: First form: Name of the the table: __________ First column name: __________ Second column na...
I am looking for a tool or system to take a look at the database and identify values that are out of the ordinary. I don't need anything to do real time checks, just a system which does processing overnight or at scheduled points. I am looking for a system at two levels: Database wide: Eg: Compare salaries of all employees and identify...
I am writing a sql editor (sqlite3). I can display a table and allow users to edit any value in the table but I now need some way of identifying the value editted. The problem is that I don't know what the primary key is and I don't think it's that good an idea to say "update table set a=b where x=123 and y=123 and z=123 and..." for all...
I'm logging in to create a new database from CMD through sqlcmd with SA account. Its response is a message: CREATE DATABASE permission denied in database 'master'. I'm using Windows server 2003 and SQL 2008. Please help me. Thanks in advance. ...