The aspect of an object which describes it as unaltered since a reference time at which a description of its state was recorded, or a description of the continued functioning of a property of the object. An example of this is checking whether the MD5 hash of this file is the same as the MD5 hash that was calculated yesterday, to ensure the file was unaltered.
Questions tagged [integrity]
300 questions
4
votes
2 answers
how to create user defined Type in Sql
i don't know how to create a domain with optional constrains?
i tried
CREATE DOMAIN idx INT CHECK (VALUE > 100 AND VALUE < 999);
but faced the below err
Unknown object type 'DOMAIN' used in a CREATE, DROP, or ALTER statement.

r bhd
- 61
- 1
- 1
- 3
4
votes
7 answers
Opening Hours Database Design
We are currently developing an application in which multiple entities have associated opening hours. Opening hours may span multiple days, or may be contained within a single day.
Ex. Opens Monday at 6:00 and closes at Friday at 18:00.
Or
Opens…

DEHAAS
- 1,294
- 11
- 17
4
votes
5 answers
How to ensure file integrity on file write failures?
Follow up to: How to safely update a file that has many readers and one writer?
In my previous questions, I figured out that you can use FileChannel's lock to ensure an ordering on reads and writes.
But how do you handle the case if the writer fails…

Pyrolistical
- 27,624
- 21
- 81
- 106
4
votes
4 answers
How to make sure the GPS position sent to the server are accurate?
here is my problem :
I have a mobile app, and I want to give the user some information depending on their position ( think something like FourSquare ). But how to make sure the user position is real ?
I mean let's say the client uses a request…

Ale_x
- 101
- 1
- 2
4
votes
2 answers
Windows 7 x64: low IL process msdn example does not work
I want to create process with low integrity level from process with medium integrity level.
I found msdn example: Designing Applications to Run at a Low Integrity Level
But it does not work on my system. Process is created successfully, but message…

Velheart
- 41
- 2
4
votes
4 answers
Prevent two users from editing the same data
I have seen a feature in different web applications including Wordpress (not sure?) that warns a user if he/she opens an article/post/page/whatever from the database, while someone else is editing the same data simultaneously.
I would like to…

Industrial
- 41,400
- 69
- 194
- 289
4
votes
3 answers
GreenHills - small data area overflow
I'm hoping maybe someone has a quick answer for this but essentially when I turn on optimizations, I get the following error:
[elxr] (error) small data area
overflow: 0xfff9f6fc (signed) didn't
fit in 16 bits while performing
relocation in…

Gary
- 1,515
- 1
- 14
- 22
4
votes
1 answer
How to verify a git merge contains no extra changes?
In git, how do I verify that a merge upstream master commit does not contain any additional diffs? Say I want to verify that the person didn't do anything 'sneaky' besides actually merge the changes from the upstream master branch.
I want to verify…

culix
- 10,188
- 6
- 36
- 52
4
votes
2 answers
Code Signing for Linux
Are there any providers offering code signing certificates for (Red Hat Enterprise) Linux? I see a lot of buzz for Microsoft-land, but not much for Linux.
I know how to generate my own certificates and embed a public certificate into my executable.…

Will Bickford
- 5,381
- 2
- 30
- 45
4
votes
1 answer
On Postgres databases, does relationship constraints degrade performance?
This is my first post here and I've tried to do my homework.
I need to have a better way to develop Data Warehouse databases for Postgres than using Power*Architect. Here is the complete sad history:
I work with Data Warehouse development, mostly…

Fábio de Salles
- 45
- 1
- 6
4
votes
0 answers
post_save user signal that creates user profile is being called twice causing duplicate key value violates unique constraint, only in admin console
I have a model called UserProfile which stores additional data about a django user.
This model has a OneToOneField to django.contrib.auth.models.User
I also have a post save signal on a User object that is fired on initial insert of a User which…

chewynougat
- 1,099
- 2
- 11
- 19
4
votes
1 answer
Incrementing the slug by avoiding Integrity error in django models save method
I have a model with two fields as below
models.py
class Publisher(models.Model):
name = models.CharField(max_length=200)
slug = models.SlugField(max_length=150, unique=True)
def save(self, *args, **kwargs):
if not self.id…

Shiva Krishna Bavandla
- 25,548
- 75
- 193
- 313
4
votes
0 answers
iOS - Programmatically check if the app is authentic
How do i check if my iOS app is code-signed with my certificate? or any other way by which i can determine that the app is original?
I've seen that its possible in case of Mac, here.
Please share info if you have come across a solution for iOS.

Ocelot
- 1,733
- 4
- 29
- 53
4
votes
3 answers
How to ensure contiguity of a tally table?
In SQL For Smarties, Joe Celko provides an ANSI SQL definition of a Series table (elsewhere called Tally or Numbers). His definition ensures the values in the column are unique, positive and contiguous from 1 up to the maximum value:
CREATE TABLE…

Iain Samuel McLean Elder
- 19,791
- 12
- 64
- 80
4
votes
3 answers
File structure to avoid data corruption
I´m currently developing an upgrade of our current media storage (To store video/audio/metadata) for a surveillance system and I´m redesigning the recording structure to a more robust solution.
I need to create some index data of the data stored in…

Eric
- 552
- 3
- 14