Hey, I'm looking for an open source database engine, that is completely written in C# (no any native dll, not mixed mode, etc...). It should support basic actions on tables (INSERT, UPDATE, SELECT, DELETE and TRUNCATE) and transactions. SQL support is not needed. Thank you. ...
Hi everybody, I'm looking for ways to back up the database of my app on an Android phone. I know that SQLite databases are just files, so I'd expect to be able to just copy the file to SD-card if one is available. However, I'm unsure as to how I'd prepare my database/activity for backup/restore. When starting, my main activity reads t...
I would like to have a SQL database online, but don't want to deal with its care and feeding. There are some commercial offerings out there for hosted DBs, for example Amazon SimpleDB. Can anybody suggest others, and if they used any of these services what their impressions were? Anything that helps me make an informed decision would be ...
Consider this simple database schema: User Course StudentCourse Student +-------------+ +-------------+ +-------------+ +-------------+ | -user_id |1 *| -course_id |1 *| -course_id |* 1| -student_id | | |---->| -user_id |---->| -student_id |---->| | +--...
I am just learning normalization, so please forgive me if this is a dumb question. I have a table TBL_Users with the Primary Key being ID. To track who is friends with who my most recent thought was to do a table with two Foreign Keys, both of which are the other person's ID. However the more I think about this I can't help but think th...
I am displaying a property from the following table given below. Now what i have to do is, find the property in the same location(suppose my property is located in sec-19, match for sec-19 and if none of them found there then search for the entire city) with the following condition that it should be posted 10 days back or if none is post...
Assume we have a popular site. We need to implement mail-like messaging between users. Typical solution is to use 2 tables: Users (user_id) Messages (message_id, sender_id (references user_id), receiver_id (references user_id), subject, body ). This method has 2 significant limitations All messages of all users are stored in one tab...
What strategies and techniques have you used to produce a data driven application that needs to access multiple diverse data sources? Specifically, Microsoft Access and SQL Server. Ideally, I'd like to make an abstraction layer that hides the physical data source from the application. Something like the ADO.NET Entity Framework would ...
In SQL Server 2000 you had DTS where you had the option to choose to export table structure along with data and also to choose specific tables only. Is there a similar option in SQé Server 2005 version. I would like to export just 5 tables along structure and data from an existing database to another database. The data is required as i...
I have been thinking and learning a lot about forms lately trying to add advanced extensions to the Spree ECommerce Platform: Subscriptions, Events, Donations, and all kinds of Surveys. Every example I have ever encountered (in blogs, in the docs, in screencasts, in source code, etc.) make forms out of Models, but they never go to anyth...
Hi I have a form that allows users to insert items in the database. I call Scope_Identity() to get last identity value inserted. This works ok. When inserting the item a passowrd is randomly generated which is also saved in my database. I need to retrieve this password as well, immediately after the item is inserted. How do I do this? ...
Back at Tech Ed in 2008, Microsoft announced that: IBM and Microsoft have agreed to work together to integrate IBM DB2 database access with Visual Studio Team System Database Edition. -- Microsoft Press Release - 6/3/2008 Has anyone seen evidence that this has actually happened? More importantly, has anyone had success moving DB...
I am trying to populate a drop down list of SQLServers on a network using the osql -L command through Java. The user will then choose a server and type in a username and password. I also need to populate another list with the databases on that server. Any ideas on how I can implement that using java? If possible, please give java cod...
I have a combo box that is currently getting its information from a database this seems to be working fine. Now I would like to have content from two fields displaying in the combo box at once. Say First Name & Last Name I've added the information to the query fine but the data displayed in the combo box seems to be controlled by the l...
What's a good way to approaching this? I would like to create a local database, just on my laptop (for now), so that I can teach myself some PHP and how to interact with databases. ... preferably a free approach... Thanks, Hristo ...
How come in my code when i use @"select Score from tblMed order by Score desc limit 10" everything works fine, but when I change "desc" to "asc" the scores don't show up??? ...
How do I get away with hardcoding the database name in referencing a table within a stored procedure. For example there are two databases db1 and db2. I am writing a stored procedure in db2 which references two tables, one from db1 and another from db2. Both are on the same sybase server. ...
I am using php and building an MVC for my web application. I am to the step where I need to connect to my DB, look at the current URL, compare that to data in my DB, and then return the correct content from my DB to the user. My question is, where should I put the code that connects to the DB and processes it? Would this go in the Mod...
For example if i have a unsigned int index in my table, what happens when i get more rows than sizeof(unsigned int) ? I'm interested in MySQL/PostgreSQL/MsSQL. ...
I'm looking for mnemonics to help me with databases, the relational model and transaction theory. For example I learned "ACID" to help me remember the properties of a transaction: atomicity, consistency, isolation, and durability. What others are out there? ...