mysql -u username -p database -e deletedata.sql I get ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'deletedata.sql' at line 1 DELETE FROM 'table1' WHERE 'column' <= date_sub(current_date, INTERVAL 37 day); DELETE FROM...
Our in-house system is built on SQL Server 2008 with a 40-table 6NF schema. Most of the tables FK to 3 others, a key few as many as 7. The system will ultimately support 100s of employees working with 10s of 1000s of customers and store 100s of 1000s of transactional records -- prime-time access should peak at 1000 rows per second. Is...
Bill Karwin has a blog post called "Why Should You Use An ORM?" which is being discussed on Reddit and I was confused about a couple of points. In it he says in the comments section: OODBMS and ORM works only on objects that we've instantiated in the application layer. I.e. there's no way to do a query like this: UPDATE B...
Between Mysql and PostgreSQL,which is suite for very large scale of data..for example, millions of record...i think,i should use PostgreSQL...any suggestion guys? ...
I was hoping I could get some recommendations or pointers to some books that could help me understand the internals about graph databases. When I say internals, I am interested mainly in Why graph databases are important, specifically what mathematical operations it excels at. Also, I would like to understand it's implementation, at le...
Hi all, I have there 2 codes on how to connect to SQL Server 2005 database. code 1 are using Dataset, and Dataadapter, code 2, didn't used neither. Can anyone please help me explain what is the differences and advatages/disadvantages on both programs..thankz code1 //create connection, dataset, dataadapter System.Data.SqlClient.SqlCon...
I'm wondering about the best approach to designing a DB connection manager for a load-balanced n-tier system. Classic n-tier looks like this: Client -> BusinessServer -> DBServer A load-balancing solution as I see it would then look like this: +--> ... +--+ +--> BusinessServer +--+-...
In which cases storing data as XML is preferable to RDBMS and why? Can you give any analogy? ...
Can somebody give me a picture as to what Matrix Tables are in the area of Database and the context in which they are best used ? Thanks, ...
I'm writing a plug-in for another program that generates a fairly complex tree structure of objects. The users will need to export this data from the plug-in for analysis and reporting. I definitely want them to be able to export to an MS Access database as it would be the most accessible for them to create quick and clean reports. But I...
Hello, I'm writing an multi-threaded app which will live on two active-active load balanced servers and access a clustered database on another server. Obviously I don't want multiple threads writing to the same records at the same time and SQL provides locking to ensure this doesn't happen. What are the advantages and disadvantages of u...
Did you ever have the following situation: you need to store information, but a part of this information is well modeled with one type of database (in a very loose sense), and another part is well modeled with another type. Examples: a set of files and additional information about each of them stored in a relational SQL database. an OO...
Hello all, The context : My current project uses VistaDB as it really fits the main scenario: the user log into the application, selects the DB (file on HDD or Network drive), does his job, then logs off. The DB (a single file) can be copied (email, usb dongle, cd ...) and transfered to colleagues or to the headquarters. And, best of al...
Hey all, I am wondering what the best way to do the following is: Query up to 5 tables (depends on user input) pull back the results and return a single array. Lets say I query table A and have the results stored as a result handle (return from the pg_query() fn), shall I go ahead and convert those to an array, and then continue append...
I'm trying to get a queryset to issue its query over a different DB connection, using a different cursor class. Does anyone know if that's possible and if so how it might be done? In psuedo-code: # setup a new db connection: db = db_connect(cursorclass=AlternateCursor) # setup a generic queryset qset = blah.objects.all() #...
I'm wondering if some other non-relational database would be a good fit for activity streams - sort of like what you see on Facebook, Flickr (http://www.flickr.com/activity), etc. Right now, I'm using MySQL but it's pretty taxing (I have tens of millions of activity records) and since they are basically read-only once written and always ...
I was wondering if there is a way to simplify this down from two queries to a single one. I'd like to be able to sort the data as I pull it out of the database and this would allow me to do it. The tables are setup like: table: files ------------------------ fileID (INT) | domainID (INT) ------------------------ table: domains ------...
I have a general questions about domains. I recogniced, that when I create a table and I don't use a domain, a default domain will be created, such as RDB$1, RDB$2, RDB$3, aso. Here are my questions: - What impact has the default created domain? - Does these enlarge my database size? - Does these have an inpact of the performance? - S...
I have a Grails app that loads its data from xml files and delivers rss feeds via rome. I don't have any domain classes and my app has no datasource. I don't want Grails to load an in memory hsql db when the application has no need for it. Deleting the DataSource.groovy file prevents me from launching the web app, it seems as though the ...
I am building an iPhone app that contains medical information for medical professionals. The data has a sort of taxonomy which is easily represented in the form of e.g. a mind map on a piece of paper. On the device, the idea is to navigate through a series of items in table views to get to a detail view with text and picture information...