All Questions
Tagged with javascript sql
8 questions
26
votes
8
answers
11k
views
Is it okay to hard-code table and column names in queries?
I've got a backend running on Node that executes queries on a PostgreSQL database. For these queries, table and column names are imported from a .env file, for example:
const ID = process.env.ID_COL;
...
- 371
4
votes
1
answer
106
views
Status Bar Timetracking Design
I'm currently developing an application in ASP.NET using SQL as the backend database. In my header, I have a status bar that displays the current status of the user and a timer that shows how long ...
- 141
0
votes
1
answer
543
views
Is there any reason not to allow negative numbers to be entered into a JSP field labeled for positive numbers?
Our application, a fairly complicated money ledger, has a JSP field for entering a certain type of money due, balanced by payments made towards that amount due. In the application, this field is ...
- 1,602
1
vote
1
answer
2k
views
Preserving Pre-formatted Multi-Line Strings in Node.js Scripts
There is a lot I don't like about PHP, but one thing I love is multi-line strings:
$query = <<<EOT
select
field1
,field2
,field3
from tableName
where
field1 = 123
EOT;
What'...
- 210
0
votes
0
answers
667
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 ...
- 1
-6
votes
6
answers
16k
views
How to not let anyone inspect elements of a webpage?
I was thinking to make some jQuery functions that will use ajax to control mysql. The whole idea is to make separate files of PHP (e.g query.php, addRow.php, update.php and delete.php) provide data to ...
1
vote
1
answer
2k
views
Implementing Syncing between localStorage and SQL database?
I have made a simple web app, which runs completely offline - all data is saved in HTML5's localStorage. Now, I want the data to get synced with the server, so that the user is able to use the app on ...
- 113
5
votes
1
answer
804
views
OpenID implementation - PHP, Javascript, MySQL
I've started doing some research on the technologies that I will need for my website.
I'm trying to implement a really simple website with OpenID user registration. The website will store a block of ...
- 53