Just to preface: I work in a small company that does ASP.NET development and uses SQL Server 2005 for all of our database needs. I was curious as to what were the pros and cons of using Visual Studio or SQL Server Management Studio for our development on the database side (i.e. table creation, stored procedure writing, etc.). Right n...
I have to develop a web application in Java, a pretty big one with loads of data to store and manipulate. I am also planning to use Hibernate and Spring. There are many databases available now like MSSQL Server, MySQL Server, Oracle, db2, etc.. Which do you recommend? Features I look for would be Java - database connection should be ...
I have quite long query with 'Q()', with Sqlite3 works very well, but with postgresql or mysql I have strange error e.g. for postgresql: invalid input syntax for integer: "(" and for mySQL: Truncated incorrect DOUBLE value: '(' How could I run that query with mysql? Where is my mistake? Here is that query: watchersTuple = self.getWa...
I am looking for a complete integrated mySQL management / admin tool (hopefully that can run in Linux). I need the ability to graphically model my tables and relationships (reverse/forward engineering would be great). I also need a tool with good data management options (i.e. basic crud). I have tried MySql workbench and it is great f...
I would like to know what is meant by the term "remapping" in MySQL, sorry If this is a noob question, It's just the first time ive heard of it. ...
Hi People! Professor ask me this question: What is the semantics of the Boolean and comparison operators in the context of three-valued-logic? I'm not sure what he meant by that. What is comparison operator? Is that the same as relational operator? Semantics? He asking about 'meaning' of those two terms in context of three-valued-log...
I tried HeidiSQL but I keep getting errors for some reason. ...
I am creating an application where there is main DB and where other data is stored in secondary databases. The secondary databases follow a "plugin" approach. I use SQL Server. A simple installation of the application will just have the mainDB, while as an option one can activate more "plug-ins" and for every plug-in there will be a new...
What is the best way for developing a database based application? We can have two approaches. One common database for all the developers. List item Separate database for all the developers. What are the pros and cons of each? And which one is better way? Edit: More then one developer is supposed to update the database and we alrea...
Hi, I study about today about 2 database design inheritance approaches: 1. Single Table Inheritance 2. Class Table Inheritance In my student opinion Single Table Inheritance make database more smaller vs other approaches because she use only 1 table. But i read that the more favorite approach is Class Table Inheritance according Bill...
Hi, I new in database, and dont know how and when mysql allocate memory space. In MySql Innodb how much storage memory allocation for empty field (no string inserted) vs not empty field? Other form of my question: When memory allocated space In MySql Innodb for varchar/text field in time of table creation or when data inserted ins...
We have a fairly straight-forward client server system - Windows app pointing to a database (SQL Server or Oracle). A separate database is set up for each customer and the customers are given several licenses of the Windows application to install on their computers. Over the years, small customizations and fixes have been applied to on...
For a long time now, we've held our data within the project's repository. We just held everything under data/sql, and each table had its own create_tablename.sql and data_tablename.sql files. We have now just deployed our 2nd project onto Scalr and we've realised it's a bit messy. The way we deploy: We have a "packageup" collection of...
I have 3 data types with -- a) Common columns b) a hierarchy -- and would like to know how to design the database. Let's say at the top level, there is a Discussion. Within that, there are DiscussionMessages, Files and Comments. They all have fields in common (UserID, CreateDate, Text), but also have unique columns (FileName, ContentT...
Here my problem; in such a case it complains about duplicate connections with same connection name: Test::Test(QString connectionName) { db=QSqlDatabase::addDatabase("QMYSQL",connectionName); } int main(int argc, char *argv[]) { QString connectionName=QString("test"); QCoreApplication a(argc, argv); Test myDb(connecti...