Tagged Questions

0
votes
1answer
15 views

Thoughts on a simple way of versioning several Database tables in code

I want to create a simple versioning system and I was wondering about some simple yet elegant design patterns. Since these tables are being used by lots of code so I need to leave them intact or all ...
2
votes
1answer
81 views

Database versioning and migration techniques for schema & data

I want to know what are the different techniques & tools used for database versioning and migration. I am also interested in saving a snapshot of the data along with the schema changes. Would that ...
2
votes
1answer
64 views

Table indexes/pk for Optimistic Locking in JPA

What is the best practice for defining table indexes for entities supporting optimistic locking? For sure, entity id has to be part of some index in DB to enable fast lookups by id. What about ...
0
votes
0answers
29 views

book for database documentation / versioning [closed]

I'm looking for a book about database documentation and versioning of database structure. I need this for my studies. I searched now for a long time time and found only some article but i need, if ...
0
votes
1answer
70 views

Hibernate versioning with OracleDB 11g “_” invalid character

Using hibernate with Oracle db 11g express edition release 2. When using the annotation @Versioned for a table "Organizations" for example, hibernate seems to try to create a table ...
4
votes
3answers
220 views

Basic mysql versioning?

We have a shopping cart as pictured below, The setup works well, except for one fatal flaw. If you place an order the order is linked to a product, so If I update the product after you have purchased ...
1
vote
1answer
60 views

Framework for revision tracking of entities in MySQL (and php)?

I have to set up a CMS in MySQL and PHP to power a website that displays information. the website won't experience much traffic. For simplicity sake, let's say this website will display information ...
0
votes
2answers
716 views

Using existing data with Liquibase?

When using Liquibase, is there any way to use existing data to generate some of the data that is to be inserted? For example, say I'd want to update a row with id 5, but I don't know up front that ...
1
vote
2answers
108 views

How should I version my data in an MS SQL shared server environment?

The server is a shared Windows hosting server with Hostgator. We are allowed "unlimited" MS SQL databases and each is allowed "unlimited" space. I'm writing the website in PHP. The data (not the DB ...
0
votes
1answer
34 views

What is you opinion about trackingdb.com? [closed]

One of the "must have" thing for a programmer is to use a version control system (for file sources). As a web developer myself, I started with using CVS; after that I used SVN and now I'm using Git. ...
4
votes
1answer
178 views

Web-app deployment and multiple versions

I'm curious to know how other developers deal with versioning of web-apps and deploying different versions. The fundamental problem is that someone might be using your web-app when you deploy a new ...
0
votes
2answers
182 views

How to update database by ant (versioning)?

I have a web application on java, which is working with database. I need an ant’s script that will deploy or update my application to latest version. There is no problem with application part, but I ...
0
votes
1answer
109 views

Two similar pieces of software using a shared database — How to do it best?

we make software for managing participants in grants given to non-profits. (for example, if your family needs food stamps, then that office must somehow track your family and report to the state) Up ...
2
votes
2answers
232 views

DatabaseSchemaUpdater bug on WP7

I have implemented some db versioning logic using DatabaseSchemaUpdater and found one issue. If i execute this code updater.DatabaseSchemaVersion = updater.DatabaseSchemaVersion + new ...
0
votes
1answer
151 views

Local database of application will be same on updated version of application

I have one application in app store. It has local database where user stores some information. Now I am planning to release the second version of the application. My question is, will the data enter ...
3
votes
1answer
224 views

Database - data versioning in single table

I'm developing a CMS which has some version control features. It's based on a MySQL Db. The idea is to show public site visitors a "certain revision" of the data and backoffice users a preview of ...
4
votes
4answers
734 views

How save text, svg, html, css all together efficiently

In an application, I am using Fabric.js, which lets users write text, draw SVG's, insert images etc. I want to know, what is the best way to store this data. Requirements are: Ability to query ...
0
votes
2answers
50 views

How do I prevent stale code from running against a newer DB? (in Django)

I'm working on a project with multiple services that share a common database. I'd like to minimize the risk that operational errors cause data corruption and one of the cases I'd like to guard against ...
4
votes
4answers
55 views

deploying multiple versions of the same views in Oracle

Any anecdotal comments or suggestions are welcome. We have applications that consume 3rd party vendor data through views. The business has requested that our applications bound to prior versions of ...
2
votes
1answer
110 views

How do I recover production data in App Engine that I accidentally deleted?

I deleted some data from my production App Engine app. Unfortunately I had the wrong table name in mind when I did so because I have two tables that have very similar names. I know the deployed code ...
7
votes
2answers
328 views

SVN database versioning for multiple developers environment

I'd like to know if there is a scenario for versioning database with SVN which will ensure no conflicts when few developers try to commit changes simultaneously. Me and my team have been using ...
2
votes
2answers
326 views

How to keep version history of datastore entities in Appengine

I'm storing an Entity A in my datastore on appengine. A has an id of type Long. I'd like to keep a history of all changes made to A's fields. What are the best practices to doing this type of version ...
2
votes
2answers
289 views

Versioning a dataset in an RDBMS using initials and deltas

I'm working on a system that mirrors remote datasets using initials and deltas. When an initial comes in, it mass deletes anything preexisting and mass inserts the fresh data. When a delta comes in, ...
12
votes
3answers
818 views

database versioning

I work as a scm developer and I am currently tasked with a activity to which involves the database versioning. Although I have done source code management I am quite new to this. Hence I would like to ...
0
votes
1answer
122 views

Workflow: SVN repository, check out and content

We have a workflow challenge regarding content and code synchronization. Our problem is that we do not exactly know what the best approach is, to manage the content of a website and the code ...
0
votes
2answers
351 views

Table Structure for versioning data

I have a table to store data for the phones and it has about 50 columns .......... should be inserted on average 30 million phones in one year ........ however, it is necessary to store a history of ...
0
votes
1answer
45 views

Generating diff based on versions

The scenario is that I have a MySQL DB on the server side, whose content is regularly updated/changed and I have 5-10 Linux clients... each of which would have a copy of the DB, and would need to have ...
4
votes
5answers
847 views

How decently track the database structure modification by SVN?

The main problem is the versioning of the database structure. The standard mysqldump and pg_dump utilities do not produce very well suited files for versioning. The dump commands produces the dump ...
6
votes
2answers
638 views

What is a good practice/tool for MSSQL database design and versioning?

We work with a small development team and a system engineer who deploys the software at certain times. At the moment we don't have any leading document for database changes. Changes are done in the ...
5
votes
1answer
971 views

Rails record versioning solution

I'm looking for a solution to version database changes in rails. Looking for something very basic. I mean like a wiki or SO edit versioning.

1 2
15 30 50 per page