Structured Query Language (SQL) is a language for managing data in relational database management systems. This tag is for general SQL programming questions; it is not for Microsoft SQL Server (for this, use the sql-server tag), nor does it refer to specific dialects of SQL on its own.
-4
votes
0answers
20 views
SQL Error: ORA-00936: missing expression [migrated]
Qns: Item Description and the treatment date of all treatments for any patients named Jessie Stange (ie GivenName is Jessie & FamilyName is Stange)
What i wrote:
SELECT DISTINCT Description, ...
1
vote
1answer
45 views
Store data for multiple User Type
I am developing an app where four types of user share same module. So is it a good idea to create:
one table and user_type and user_id (something like that)
table prefixes basically 4 diff tables of ...
1
vote
2answers
84 views
Configurable tables in sql database
I have the following tables in my database:
Config Table:
======================================
Start_Range | End Range | Config_id
10 | 15 | 1
...
5
votes
1answer
254 views
Is inline SQL still classed as bad practice now that we have Micro ORMs?
This is a bit of an open ended question but I wanted some opinions, as I grew up in a world where inline SQL scripts were the norm, then we were all made very aware of SQL injection based issues, and ...
0
votes
2answers
60 views
Using lucene and sql server togheter. Newbie needs directions [on hold]
Basically the whole thing can be explained simply:
I need to index one or more SQL Server 2005 databases with lucene so I can search the various records.
I found a lot of examples and documentation ...
1
vote
1answer
57 views
structure problem in Relational DBMS creation
For learning and understanding purpose, I currently want to try to make a small relational DBMS with simple features like (for now) only sequential reading/writing and CREATE TABLE, INSERT, SELECT, ...
5
votes
1answer
161 views
SQLite with two python processes accessing it: one reading, one writing
I'm developing a small system with two components: one polls data from an internet resource and translates it into sql data to persist it locally; the second one reads that sql data from the local ...
2
votes
4answers
288 views
Database is performing slow, even all the tables are having normalization
One of the interviewers asked me this question:
Tables are created with appropriate normalization rules, However the database is performing slow. [Ie.: The select, insert statements are taking ...
0
votes
1answer
185 views
C# Design for SQL connection and commands
Currently I'm working on system that works with database, and I would like to have it done elegant way. So I have abstracted DBConnection into one class, DBCommands into another class. (DBCommands : ...
-1
votes
2answers
193 views
SQL API instead of a REST API? [closed]
What are the pros and cons of exposing an SQL API instead of a REST API?
Let's assume that this would be a private API – the API developer and user are on the same team.
Probably the biggest problem ...
9
votes
7answers
26 views
Nested Entities and calculation on leaf entity property - SQL or NoSQL approach
I am working on a hobby project called Menu/Recipe Management.
This is how my entities and their relations look like.
A Nutrient has properties Code and Value
An Ingredient has a collection of ...
10
votes
3answers
894 views
Why many designs ignore normalization in RDBMS?
I got to see many designs that normalization wasn't the first consideration in decision making phase.
In many cases those designs included more than 30 columns, and the main approach was "to put ...
0
votes
0answers
4 views
SQL query question, what does this statement mean (au.ExNetBits | 8) [migrated]
I am redeveloping an application and have found this sql statement, what does the | character do in this part (au.ExNetBits | 8), i havent seen before and cant find any answer online?
SELECT ...
-1
votes
3answers
208 views
What would be a good “umbrella” term for HTML, CSS, SQL, JavaScript and the like? [closed]
There appears to be a pretty clear consensus on the question about whether HTML and CSS are programming languages. They are not.
HTML is a markup language and CSS is a stylesheet language. You could ...
0
votes
0answers
19 views
Oracle SQL Query with Additional Summation Columns [migrated]
Suppose I have a table that has USER_ID and a AMOUNT columns. For each row, there could be a positive or negative amount in the AMOUNT column.
I'm looking for a way to select from this table such ...
