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.
-2
votes
0answers
24 views
Plotting SQL Data on the web [on hold]
I am working on a project where I need to plot data from an SQL server onto the web. I am a complete beginner when it comes to this, and was wondering if I could get some help or general advice. I ...
3
votes
2answers
1k views
One of my team members committed SQL injection-vulnerable code; should I report it to the manager? [on hold]
One of my team members committed a huge mistake; a clear SQL injection-vulnerability. It obviously didn't pass my peer review and I made very clear that this is unacceptable. I never saw this ...
0
votes
3answers
213 views
Using SQL queries in loops
Is it a bad idea? I need to compare each entry.Key value in a Dictionary of strings to a SQL table. If there is a match, then I pull the data from that row.
I was originally going to use a foreach ...
31
votes
9answers
2k views
Is there any material difference between queries joined by WHERE clauses, and queries using an actual JOIN?
In Learn SQL the Hard Way (exercise six), the author presents the following query:
SELECT pet.id, pet.name, pet.age, pet.dead
FROM pet, person_pet, person
WHERE
pet.id = person_pet.pet_id ...
-1
votes
2answers
90 views
Storing Dates & Times in SQL [on hold]
I have a tool that I am working on which allows people to create meetings. They can select the Date, Time & Timezone that this meeting is occurring in.
I need to determine the best way to store ...
0
votes
1answer
73 views
Should I use foreign keys in my database if I use laravel?
I'm creating a website with Laravel for the first time. I checked relationships documentation today and it seems that Laravel just uses simple SQL queries.
class User extends Eloquent {
public ...
3
votes
3answers
349 views
What kind of user info is ok to be stored as plain text in SQL Database?
I'm practicing around building e-commerce asp.net applications that allows for users to register to the site and their user credentials are stored in a MySQL database. In my sample project the ...
0
votes
2answers
139 views
Clients connect to WCF or SQL Server
I was wondering what is the prefered way of accessing data from a server in a client application. The data will be stored on the server in an SQL database and I have previously used the following 2 ...
1
vote
1answer
82 views
Implementing “Trending Items” using linear regression in SQL Server
I'm building an MVC .NET website where people can rate and review movies (similar to IMDb). I'm using SQL Server for the back-end.
I'll be implementing a feature where the homepage displays trending ...
0
votes
2answers
77 views
Sending a notification to each participant 3 hours before the meeting starts
Let's assume an application that deals with meetings where some users will participate.
What is an efficient way to achieve this use case:
3 hours before the meeting should start, one reminder mail ...
3
votes
1answer
103 views
What is the best way to format complex SQL queries in Node?
I am using node-mysql to query a MySQL database via Express and Node. My queries are getting fairly complex and I want to format them across multiple lines. However, the only way I could accomplish ...
10
votes
4answers
755 views
Historical precedent for why Prolog is less popular than SQL in Imperative Programming? [closed]
It seems that writing Declarative SQL is very popular in Imperative Programming. However, it also seems that writing Declarative Prolog could save a lot of complexity but this is not very common.
...
3
votes
3answers
305 views
ASP.NET MVC should I reference the DAL from the UI?
I am developing an ASP.NET MVC application, and I have three projects:
UI (with the system.web.mvc reference, BL and DAL references)
BL (business facade and business objects)
DAL (contains my ...
0
votes
1answer
40 views
Django Project Logic Solution
I'm starting to develop my first webapp, and I'm using django.
Before anything I'm working on the software logic, how it should work, the links and objects it needs.
The problem is:
I need the app ...
2
votes
5answers
172 views
Stored Procedures, ORMs and other application layers
I'm just starting out on a project to develop a new, fairly substantial web application which has an underlying MSSQL database. We're hiring a team of developers to write the application (in .NET) and ...
-5
votes
1answer
72 views
How best to design a SQL Parser in java, any prevailing design pattern comes to mind? [closed]
What software pattern is most useful for building a SQL Parser?
I would like some ideas on how to even get started on something like this.
2
votes
2answers
185 views
An algorithm that spreads similar items across a list
I need an algorithm that distributes same items across a list, so maximizing the distance between occurrences.
E.g.
I have a list of 15 items:
{a,b,c,c,c,d,e,f,f,f,g,h,h,i,j}
The algorithm should ...
31
votes
3answers
1k views
Why is most SQL written in YELLING? [duplicate]
On MySQL at least, the following two queries are functionally identical:
select * from users limit 0, 1000;
SELECT * FROM users LIMIT 0, 1000;
However, most example sites and most developers I've ...
0
votes
2answers
56 views
Efficient database access for related data
As an example for this question, consider a content management system that has a content database table which contains things like the page title and location as well as the content itself which could ...
1
vote
1answer
219 views
Best OOP pattern to use for creating a commandline SQL API for a proprietary json based company datastore
We need to create a SQL commandline tool for querying a proprietary json based datastore. I'll be using java. Any suggestions on the primary OOP design pattern I should use for building this API?
...
-1
votes
1answer
258 views
SQLDatabase: Read a lot of data at once and process in memory or read the data when I need it?
I'm not sure how to approach this problem.
I require a big chunk of data records from the SQL server. This chunk is based on variables, so I don't know before what records I need.
I need to do a large ...
1
vote
1answer
94 views
Database choice [closed]
I am working on a system where I am replacing and existing Cobol system with C#.
For the database I have hit some requirement which I am having a hard time to find complete support for (tried SQLite ...
3
votes
3answers
216 views
Is there a 'standard' SQL that can replace all the various custom versions?
I have been writing SQL for over 10 years now. I am extremely proficient at it and have experience working in SQL Server, Oracle, MySQL, PostgreSQL, etc. While there are multiple standards out there, ...
2
votes
2answers
121 views
Combine union with distinct
Situation: I need distinct results from two tables, that both have duplicates.
I would like to know if I should combine UNION and DISTINCT.
Example 1 - Only use distinct
SELECT DistinctValue
FROM ...
15
votes
4answers
4k views
Databases: Where should the application logic run? [duplicate]
http://highscalability.com/blog/2010/11/9/facebook-uses-non-stored-procedures-to-update-social-graphs.html talks about how Facebook moved logic out of the database into the application in order to ...
3
votes
4answers
335 views
Organise C++ classes around SQL database
My question is about how best to organize C++ classes around a database
model, and I understand this may appear very elementary.
The software I propose to create will do the following. It is intended ...
0
votes
0answers
50 views
An algorithm to implement SQL's ORDER BY with TOP/LIMIT or OFFSET/FETCH
Is there a general algorithm to implement SQL's ORDER BY with OFFSET/LIMIT more efficiently than sorting all the records?
The algorithm for a simple TOP x is easy enough. It takes one full pass ...
1
vote
0answers
204 views
Separation of concerns between repository and service in DDD with complex entities
This probably seems as an example of opinion-based question, but I'm actually looking for rationale on how to decide correctly, I believe there is a correct solution that can be backed by solid ...
3
votes
2answers
266 views
Does ODBC require any run-time software beyond an .exe file to run against MySQL and ORACLE SQL? [closed]
I'm writing a software [under Windows] in C++ which later needs to be able to connect to both MySQL and ORACLE SQL. Now the software needs to be as simple for the user as possible.
Now I'm ...
0
votes
0answers
45 views
Database conceptual Question [duplicate]
When querying in database through PHP, is it good to open mysql connection before every query and close it as the query completes? or should we open the mysql connection as soon as the first query ...
0
votes
0answers
55 views
embedding LEFT OUTER JOIN within INNER JOIN
I am having some problems with one of the question's answered in the book "SQL FOR MERE MORTALS".
Here is the problem statement
Here is the Database Structure
Here is the answer which I am ...
0
votes
2answers
123 views
Is it a bad practice to keep database schema scripts (DDL) and manipulation (DML) scripts in different modules
we have a project structure like the following
"module-shared" module depends on "module-database" module and some other modules depend on "module-shared" but no other module depends on ...
4
votes
2answers
270 views
Entity Framework with no direct table access
There are some similar questions I've found here, but none of them fully answer the question I'm asking. Similar questions: here and here
In my company, I develop C# .NET applications and our Server ...
1
vote
1answer
274 views
Should ORM data access methods be wrapped or used directly?
We're using an internally-built ORM. Each table is represented by a Model class, which inherits from a base model class that has a handful of methods like GetAll, GetWhere (to get rows with specified ...
-4
votes
1answer
94 views
what data storage method should I use? [closed]
I am currently writing a program and among other things need to store data.
The program listens to two computers talking to each other in a known protocol (the program know what protocol it is,the ...
0
votes
2answers
58 views
Changing an int to be a string in PHP / MySQL Schema
Background
I'm trying to decide the best way to manage a change in requirements.
Currently when an admin is assigned to a ticket, the ticket header record is given an owner and the ownerID field is ...
-1
votes
3answers
204 views
What constitutes a good Database System(Java / SQL related) [closed]
I've given this so much research but still couldn't come to my own conclusion, before continuing this question I would like to give you a rough idea of my current situation. I'm 18 years old and have ...
3
votes
2answers
87 views
An algorithm for finding subset matching criteria?
I recently came up with a problem which I would like to share some thoughts about with someone on this forum. This relates to finding a subset. In reality it is more complicated, but I tried to ...
0
votes
2answers
58 views
Managing unique data correctly in SQL
Here in Brazil we have a personal identifier called CPF. This identifier has a sequence of 11 digits and is unique for each Brazilian citizen. Possibly in other countries there is something like that ...
1
vote
1answer
208 views
Web-app filtering information client-side vs server-side?
I have a web-app that provides data (that is updated on an interval) for intranet users, who are able to filter information by location.
I was having a discussion with a co-worker about whether that ...
0
votes
1answer
138 views
Refactoring a Single Rails Model with large methods & long join queries trying to do everything
I have a working Ruby on Rails Model that I suspect is inefficient, hard to maintain, and full of unnecessary SQL join queries. I want to optimize and refactor this Model (Quiz.rb) to comply with ...
0
votes
0answers
130 views
Javascript and SQL Lite (multi browser offline SQL/database query)
I'm in the elections division of my county and am trying to simplify a voter lookup method for our poll judges during election time. Currently we are using a clunky heavy application that the judges ...
0
votes
2answers
97 views
What is selection and what is projection
I am working on Android with the query() method of the ContentResolver class and it accepts 6 parameters, (uri,projection,selection,selectionArgs,sortOrder,cancellationSignal) for selection and ...
2
votes
3answers
149 views
Managing database schema for a C++ app
I have an open source project (Cockatrice) that uses mysql for the server component. I'm planning some changes to the schema, but right now the only management I have is a script that runs the proper ...
2
votes
1answer
470 views
When deciding a Primary Key, can I use Date part of a DateTime field
I'm designing a payroll system I have designed a database with several tables and this question is related to following tables
EMPLOYEE (Employee_ID [pk], Name,... etc)
LOCATION (Location_ID [pk], ...
0
votes
1answer
127 views
Full Text Indexing Strategy for MS Excel Documents
Background
As part of a broader application that allows users to search thousands of MS Office documents on a private network, I need to index and make searchable Microsoft Excel files.
My basic ...
1
vote
1answer
33 views
Custom Domain or Attribute Reference Table or Both?
I'm designing my first real database and I'm weighing the pros and cons of how to enforce uniformity in my data. My first option is to create a custom domain and program my UI to only allow certain ...
0
votes
1answer
159 views
Simplifying data search using .NET
An example on the asp.net site has an example of using Linq to create a search feature on a Music album site using MVC. The code looks like this -
public ActionResult Index(string movieGenre, string ...
1
vote
1answer
144 views
Dynamic Query Generation : suggestion for better approaches [closed]
I am currently designing a functionality in my Web Application where the verified user of the application can execute queries which he wishes to from the predefined set of queries with where clause ...
1
vote
0answers
97 views
Serialized values or separate table, which is more efficient?
I have a Rails model email_condition_string with a word column in it. Now I have another model called request_creation_email_config with the following columns
admin_filter_group:references
...
