Looking for solutions that push the envelope and: Avoid Manually writing SQL queries(Python can be more OO not passing DSL strings) Using non-Python datatypes for a supposedly required model definition Using a new class of types rather than perfectly good native Python types Boast Using Python objects Using Object Oriented and key...
I've seen some people use the maven-sql-plugin to do this. But it seems like a task that is better suited for DBUnit....perhaps at the beginning of an entire test suite. What's the best practice here? ...
I have to save the following variables to a database: string PoliciaID = Session["username"]; string PlacaAuto = Page.Request.QueryString["placaauto"]; string Carnet = Page.Request.QueryString["carnet"]; string Fecha = DateTime.Now; string TipoInfraccion = Page.Request.QueryString["tipo"]; Polic...
In one of my Django projects that use MySQL as the database, I need to have a date fields that accept also "partial" dates like only year (YYYY) and year and month (YYYY-MM) plus normal date (YYYY-MM-DD). The date field in MySQL can deal with that by accepting 00 for the month and the day. So 2010-00-00 is valid in MySQL and it represen...
I have a user defined type, which is a datatable in an SqlServer database. I have been using Database, DbCommand, etc to call stored procedures and get a Dataset back. Datasets are handy in that they can contain multiple tables. Now I want to pass a Datatable in, so I tried: string _strComText = "stored_procedure_name_changed_to_protec...
I am wondering what the best ways to store graphs in persistent storage are, for later analysis, search, clustering, etc. I see neo4j being an option, I am curious if there are also other graph databases available. Does anyone have any insights into how larger social networks store their graph based data (or other sites that require the...
So this question is more around the design decision than anything else.Essientially, I want to build a iPhone/iPad app that will allow users to manage their database. Now there are two ways of doing this (i think). Create native objective-c drivers for each database that provide a complete wrapper around creating/managing databases (ta...
For my next app, users will likely have a number of 'points' which changes constantly. For example, a user might accrue a number of points for performing a task, have points taken away, or have points donated to them. I'm wondering whether to store that value and update it constantly in addition to a 'history' table (which would contain...
Here is my query: $query="Delete b Where Exists ( Select 1 From a Where a.poster_password = '$pass' And a.ad_id = '$id' And a.classified_id = b.classified_id ) Delete a Where a.poster_password = '$pass' And a.ad_id = '$id'"; I get this error: "You have an error in your SQL syntax; chec...
Hi, I've designed a database structure where data is collected about cars over a period of time, for research purposes. The owner of the car enters a large amount of related data each month about the car, it's performance etc. However, I now have to handle situations where ownership of the car is transferred (possibly more than once), a...
I want to connect php to Access without using ODBC connection like MySQL. Please give me solution. and also tell how to connect with SQL Oracle and other databases. ...
I want to use a SET datatype for my databse. So that a field of that type can contain one or more values from that data type. But I have following two questions: Q1. Is SET is correct to use as a datatype in a database? I think that its not supported by all the databases. Q2. If SET is not a good option, then what can I use in place o...
Is it not possible to perform two deletes in one query by separating them with a semicolon? Here is my query: $query="DELETE FROM $sql_table WHERE EXISTS ( SELECT 1 FROM classified WHERE classified.poster_password = '$pass' AND classified.ad_id = '$id' AND classified.classified_id = $sql_table.classified_id ...
Hi guys! I need to add a table to store user settings. For the first time users will have about 10 different settings, but I'm sure there will be more. What scalable structure of database table to store user settings would you suggest? Any help would be greatly appreciated. Thank you! ...
Hi. Recently I inherited a database from another programmer (created / stored with SQL Management Studio 2008), and I am having massive difficulties accessing, modifying, or even viewing the previously created databases. Specifically, when I try to load one of the databases in SQL Management Studio I get the following error message: ...
Hi, Here's my problem : my site has users, which can create projects, and access other user's projects. Each project can assign different rights to users. So, i could have Project A : user "John" is in group "manager" , and Project "B" user "John" is in group "worker". How could I use the Django User authentication model to do that ? ...
Sometimes I need to develop a simple database application using MS Access Databases. I`ve learned that I can manipulate data in my tables using direct SQL Commands or gather everything in a DataSet and update any changes that it tracks (insert, delete...). But the question is: should my app make changes is my database tables using dire...
Basic requirements Fault tolerant (ex. has to work even when an entire data center goes down) Maximum number of records are about 1-5 billion Has to work properly and comparatively fast under high load Compatible with JavaEE Prefer relative DB but in general it doesn't matter Free of charge Do you have any ideas? ...
This is something I deal periodically with, and first time it was me who needed conviction. Luckily, I just tried, made extra effort to learn and thanks to this book, Spring support, and Hibernate I won't start a project without considering JPA. But not everyone is willing to go extra mile that often (just in anything we deal with I gues...
Is there any (mysql) db diff tool that can output the differences between 2 dump files (or 2 db) as a series of ddl and dml sql statements? I would like to maintain the db version controlled and so far the 'best' option i've seen is create a initial dump of the database and then put the modifications as a serie of scripts. The problem ...