All Questions
Tagged with sql web-development
13
questions
1
vote
0
answers
39
views
Storing SQL for table creation
I am currently working on a small web-app stored in a monorepo and using PSQL as database (hosted on GCP). It's my first time working for a web app and I have to create a lot of tables manually such ...
1
vote
0
answers
74
views
Issues Regarding Data Model Abstraction in Golang
I am currently writing a quiz web-app with a React front-end and a Golang backend, with a PostgreSQL database to keep track of the quizzes, the questions on the quizzes, and the choices in the ...
1
vote
1
answer
207
views
Writing a SQL recordset as a HTML Table - a bad practice?
I'm maintaining an intranet using ASP Classic. Some of pages looks like one or more HTML tables used for administration tasks.
Those tables are obtained by SQL requests. Server side, they are kind of &...
1
vote
0
answers
995
views
How to store articles (with text and images) in SQLAlchemy database
I'm working on a blog-like application with Flask and SQLAlchemy and I'm unsure how to store the blog posts (articles) in the database. These are going to contain text and images (placed between ...
1
vote
2
answers
838
views
What problems arise from writing PHP for IIS/SQL Server rather than Apache/MySQL?
I'm a .NET developer, currently writing an ASP.NET site hosted on our local servers with Windows, IIS, and SQL Server. We're speaking to a company in India about hiring a developer for a different ...
5
votes
2
answers
180
views
What strategy should I employ using C# to solve this use case?
So this is all hypothetical and theoretical really. This isn't a real system I'd have to architect, but its a good question.
A company stores and reproduces contracts. Contracts can have many ...
6
votes
1
answer
11k
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 ...
1
vote
1
answer
444
views
Do software developers write SQL? [closed]
Do software developers write SQL or database developers provide the SQL and the software developers use it? I am a novice to software development. I am just trying to understand the software ...
23
votes
1
answer
17k
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 ...
1
vote
3
answers
266
views
How to maintain user relationship when user un-follows another user
I have a table of user relationship which stores who follows whom, the table structure is as follows
-id
-follower
-following
when someone follows any other user, I add a record with follower user ...
4
votes
2
answers
2k
views
Is a traditional client app which connects directly to a database a good idea?
After using Django's excellent admin interface, I was pondering creating a similar system which wasn't as tied to an ORM.
Now, while considering this, I thought that overcoming webapps limitations (...
18
votes
2
answers
2k
views
Does F# offer anything particularly useful for database-driven web development?
My organization finally upgraded to MS Visual Studio 2010 this year. One of the big new features that Visual Studio 2010 offers is the F# programming language.
I understand that F# offers a ...
0
votes
5
answers
5k
views
Developing a simple web-application? [closed]
I decided to do a mini-project by myself to help me understand a bit more about developing web applications before starting the new university semester. Using the Java SE and JEE/J2EE platforms. I ...