database

Core data query on a NSSet of NSSet

Hi everyone, I'm struggling with core data... I don't understand some things so if someone could help me, I would be very grateful! I have an entity (Recipe) with a relationship to-many with another one (Meal). I would like to select all the recipes which have no connection with a meal... so I've tried: Code: [myRecipes filteredSetUsin...

Change entire db's collation and solve illegal mix of collations

Hi I'm having a problem when doing LIKE '' queries in mySQL These are my variables character_set_client utf8 character_set_connection utf8 character_set_database latin1 character_set_filesystem binary character_set_results utf8 character_set_server latin1 character_set_system utf8 character_sets_dir C:\xampp\mysql\share\charsets\ 1...

Is it bad practice to query two different databases on one page?

I'm working with a programmer who doesn't want me touching his database... I would like work with a database instead of hard coding my content but don't want the sites performance to suffer. Is it bad practice to query two different databases on one page? If its not a problem is there a limit to how many databases you can query per pa...

Delivery of JMS message before the transaction is committed

Hi, I have a very simple scenario involving a database and a JMS in an application server (Glassfish). The scenario is dead simple: 1. an EJB inserts a row in the database and sends a message. 2. when the message is delivered with an MDB, the row is read and updated. The problem is that sometimes the message is delivered before the...

Benefits to NOT trimming strings of leading and trailing white spaces in database applications

I am not a developer, but I have spent years testing and managing software projects. Bugs caused by leading and trailing white space in strings are like war wounds that will never completely heal. So I ask, in what situations are leading and trailing white spaces beneficial? ...

Should core application configuration be stored in the database, and if so what should be done to secure them?

I'm writing an application around a lot of hierarchical data. Currently the hierarchy is fixed, but it's likely that new items will be added to the hierarchy in the future. (please let them be leaves) My current application and database design is fairly generic and nothing dealing with specific nodes in the hierarchy is hardcoded, with...

Delete Old or Redundant Post Metadata from Wordpress

Hello - it appears that somehow in the past, wordpress saved multiple redundant post-meta for post revisions which are no longer in the database. As a result, I have a ton of post-meta that does nothing and is tied to posts that no longer exist. Does anyone know how to remove this data in myPHPAdmin with a SQL querey? Thanks in advanc...

How do I get a column type "date" inserted into FULLTEXT in a mysql table?

I am making a control panel for administrators on my site that is a search function. When you enter a name it pulls the users first name,last name, email and password. When I tried to insert Birthday into the FULLTEXT to include it in the search, it is not on the drop down. I think because its type is 'date'. Is there a way around that? ...

Version of SQLite used in Android?

Reason: Im wondering how to handle schema migrations. The newer SQLite versions support an "ALTER TABLE" SQL command which would save me having to copy data, drop the table, recreate table and re-insert data. ...

How do you paginate results from a dynamic search in Django?

I'm currently building a simple search method for some designs. The query searches both the name of the author and the text of the design. The problem: what happens when the database has 300,000 designs and I want to paginate the results? If I pass a page variable, then each time a user switches to a different page, the query is executed...

Android: is it possible to access a sqlite file that is bundled with my application?

I have a database that I have already populated locally. I want to bundle it with my applications and access it at runtime (never want to re-write it anywhere, nor write to the database, simply read). What is the path of a file that I have added to the bundle? And, can i use that path with a SQLiteDatabase.openDatabase ? ...

Scalable and performant way to run calculations against a database

A multitennant database for use by telsales agents, a table contains the prospect leads to call. One record is displayed to the agent at a time for him to call, after the call the agent updates the record with a coded call outcome taken from the outcome table. In this table some outcomes have a recycle time, after which the record should...

ASP.NET Login failed for user 'NT AUTHORITY\NETWORK SERVICE'

Hello all, I'm trying to publish an asp.net website on a remote server. When my code tries to connect to the database, I get the error message described in the question title. Now, I've gone into the Microsoft SQL Server Management Studio for SSE 2008 and can see the list of logins. NT AUTHORITY\NETWORK SERVICE is there, but I'm not sur...

MySQL Replication and Upgrading an App on Master

I've got a master-slave replication setup for a suite of applications. One of those applications is a forum, which writes directly to the master. The rest just read from the slave. The forum database is huge (~10GB) which causes some issues re: backups and data transfers (even a mysqlhotcopy takes 20 minutes). I want to run an upgrade...

Reading in bytes produced by PHP script in Java to create a bitmap

I'm having trouble getting the compressed jpeg image (stored as a blob in my database). here is the snippet of code I use to output the image that I have in my database: if($row = mysql_fetch_array($sql)) { $size = $row['image_size']; $image = $row['image']; if($image == null){ echo "no image!"; } else { ...

Core data select objects from an array - iPhone

Hi everyone, I was wondering if I could select objects based on a predicate with an array... for example Code: [NSPredicate predicateWithFormat:@"id=%@", arrayOfID]; Will it work? If no, how can I do it? Best ...

Why does Doctrine create an index on only one column in the linking table?

Just like stackoverflow, there is a many-to-many relationship between Question and Tag. After running these symfony commands: ./symfony doctrine:drop-db ./symfony doctrine:build-db ./symfony doctrine:build-model ./symfony doctrine:build-sql ./symfony doctrine:insert-sql With the following schema: schema.yml Tag: columns: name: ...

Database developer vs database administator, which way to go?

I'm still confused about these jobs. I believe that DB admins monitor, manage and maintain database(s). But what exactly DB developers do? Do they write query to create table, to update database,... or they write programs (in ADO.NET, for example) to connect and manipulate data? What are the cons and pros of these jobs? Can you tell me?...

C++ with fstream or database

Hey guys, I am trying to implement a image recognition program in C++. I had completed the extracted of feature, now trying to save the large amount of numbers. I had 2 implementation in mind, one is to save the data into binary files, to reduce the overhead of computation, or i can use database to keep the information. Binary file is fa...

Difference between "COMPRESS FOR ALL OPERATIONS" and "COMPRESS FOR OLTP"?

I was looking through Oracle's OLTP Table Compression (11g onwards) documentation as well as online resources to find the syntax and came across two different versions: COMPRESS FOR ALL OPERATIONS and COMPRESS FOR OLTP The documentation I looked through didn't mention any alternative syntax, so i was wondering if anyone here might...