I'm currently planning out a desktop-application that is used to organize stuff. I want to open source it on one point and I want to use and embrace open standards for everything.
There is just one ...

I originally started writing a question on StackOverflow about a clever way to optimise keeping a version history of large text fields in a relational database table, possibly by using deltas instead ...

I have been thinking what could be the fastest way to show base64/img data to the user, i could generate the data when the user is registered and then store it to database, or generate it every time ...

In my application, I have a lot of SQL queries that have business logic embedded in them. For example, in searches I 'hide' results that are low ranked, less than -5 'community rating' because those ...

I have programmed a library in C#, which process some EDI into meaningful data based on the DB structure of a table. I have used a typed dataset in the class library project.
Now I run into an issue ...

I have a database table with numerous fields including "category". The source of this table is an xml file which the system receiving occasionally. Each xml file contains data for one category. The ...

I have a functional sign up page for a blog that updates a database with a users name, email, profile picture and a short bio. The General information page and the profile picture upload/bio page are ...

I am going through the stored procedures written throughout our project and see that multiple distinct queries are written inside a single stored procedure and are called by passing different values ...

What's the best approach to design an android application with the question title specification?
The application will show a first list of buttons with an alphabetical classification (like button1: ...

Question 1. What is the language used in Microsoft SQL Server?
Question 2. I get confused with the name Microsoft SQL Server since its a RDBMS why its name ends as "Server". Because server is used to ...

In our API we've got a few central datatypes which need to be "decorated" (so to speak) after retrieval from the database with calculated values. The database is accessed through an ORM which follows ...

I'm creating a system to store holidays and events. I have a basic understanding of the schema for the static dates (every 23rd of march for instance).
My trouble lies with the relative dates (i.e. ...

I want to verify that my services (used to collect data from database and handle it according logic) are not connecting to production database which can cause data loss.
my first idea was to mark the ...

What would be better DB design for a social network website.
A single table with more columns and less rows or multiple table with fewer columns but more rows.
For example:
User can post an update on ...

This is a direct follower to this question. An answer given to that questions says (my understanding), that nowadays using string-based enums instead of integers isn't a much problem, because hosting ...

My boss is the db administrator in a new software project and he came up with that design where every table will have both a auto-increment clustered key and a guid primary key (or possibly composite ...

I am pretty interested in the idea of using multiple datastores to support a single application and understand the benefits in theory but would like to know a little more about how things are done in ...

We are planning to develop a cloud based database driven web application which we would like world to use. Till date at the database side we have used fully normalized way to store the data and use ...

What is faster performance wise? Creating a REST API and having your web app use the REST API to do all interactions with your database OR querying your database directly (i.e. using whatever typical ...

Probably a poor choice of title but can't think how else to word it.
I am developing an app for a company using CakePHP (MVC Framework).
I have built a "Status" model which essentially has an an ID ...

Why don't Windows/Linux use relational databases (RDBMS)?
I know they use file systems to store all data but don't you think it is more efficient to use databases like we use in web sites/web apps?
...

Good day. I need help for a specific case. A little background: We have an existing app, it is like a PDF viewer, and you can draw freehand, highlight, add highlight with notes, add action items, etc. ...