Questions tagged [sql]
Structured Query Language is a language for interacting with relational databases. Read the tag wiki's guidelines for requesting SQL reviews: 1) Provide context, 2) Include the schema, 3) If asking about performance, include indexes and the output of EXPLAIN SELECT.
1,461
questions
3
votes
1
answer
98
views
SE Data Explorer: Users by City
I view users by city using this SQL query:
...
1
vote
0
answers
142
views
ContactEditor - Excel VBA db app: Storage Library
ContactEditor uses Excel VBA as a prototyping platform for a personal information manager combining the "Model, View, Presenter" (MVP) pattern and a persistent storage manager.
Fig. 1. Data ...
3
votes
1
answer
541
views
VBA introspection library for SQLite
SQLiteDB VBA Library is a set of VBA helper functions for the SQLite engine. The primary motivation behind this project is to provide convenient access to extended introspection features. Because of ...
0
votes
2
answers
100
views
Efficient way to build table within database or update it using C#
I have a headless application that does either of two things.
If table does not exist within database create it and copy all the data over
OR
If table exists update it
Now I usually use access ...
2
votes
3
answers
230
views
Queries for storing and get information from postgreSQL
I have been working with postgresql where I am trying to get information from database, update, exists and much more. I have created a context manager for commit and to close whenever it is in ...
4
votes
3
answers
2k
views
Optimizing the insertion of 400 000 records in sqlite
I have the python script that creates a sqlite database and fills it with data (originally coming from a json file). At the time I execute the code below, my word ...
0
votes
1
answer
30
views
Appending script from within function to header [closed]
I'm attempting to import an external script into an HTML file. The name of the js file that I want to import is hosted in a SQL database. Therefore, I am using a XMLHttpRequest to access the SQL ...
3
votes
4
answers
183
views
Order a table by column and get row number
In my database, I have table wp_postmeta, example:
...
0
votes
4
answers
246
views
Appointment database - design II
I want to create a database which gives an admin user ability to create schedule for other users to book from. This is second edition of this database schema.
I would like to know if there are any ...
1
vote
1
answer
287
views
Appointment database design - Schema
How would you go about designing a database for service appointment?
Here is what i came up with so far. Let me know if there is a better way.
Basically the admin should be able to build services list,...
-1
votes
1
answer
72
views
IF SELECT statement will break SQL ACID Compliance? [closed]
My QA told me that I should not use IF SELECT before doing an UPDATE statement because it will breaks the atomicity of a ...
1
vote
1
answer
1k
views
SQL for precision and recall?
I have a table containing two versions of results for some predictors, one by human labeling and the other by machine predicting, and I want to calculate some metrics.
...
3
votes
2
answers
150
views
Alter authorization on all non-system SQL Server databases
I am not very experienced with T-SQL and feel this can be done better. The script changes ownership of all "user" (non-system) databases to sa.
Usage of a ...
4
votes
2
answers
205
views
Using a transaction to create account records
This is my first time using commit and rollback. I just need to know if this is a proper execution of the functions for this particular situation:
...
0
votes
1
answer
68
views
Evaluate my program with Java Mail + Sql + Swing
I'm 16 years old and no one to help me, no one to give any advice or constructive criticism, I'm aimless. I'll leave the link to my last code (github), a program that sends an email to everyone ...