All Questions
15 questions
-1
votes
1
answer
134
views
How can I display book details in Laravel using Eloquent join and where clauses?
Undefined property: Illuminate\Database\Query\Builder::$title
public function show(string $id) {
$books = DB::table("book_tbls")
->where("author_tbls.id", "=&...
- 1
-2
votes
1
answer
107
views
How to write deadlock-proof upsert T-SQL? [closed]
For a web api performing standard CRUD operations against a database :
For the DML CUD operations I could see two strategies at the endpoint :
Strategy 1 : CUD SPs accept params for table keys. First ...
- 8,937
0
votes
1
answer
79
views
SQLALCHEMY - returning a pretty format [duplicate]
I am trying to create a basic CRUD application with python using sqlalchemy. It is just a virtual contact book, that runs in the terminal.
I have managed to create this and get it working successfully,...
- 65
5
votes
1
answer
20k
views
Most efficient way of updating ~100 million rows in Postgresql database?
I have a database with a single table. This table will need to be updated every few weeks. We need to ingest third-party data into it and it will contain 100-120 million rows. So the flow is basically:...
- 1,075
0
votes
0
answers
252
views
Laravel 7 CRUD (Update) doesn't have error but db is not updating
I am trying to update a data but it doesn't change in the database. The ajax tells that the data is successful and the console did not show any error. Please help me. I need to finish this before ...
0
votes
0
answers
80
views
How to update many-to-one entities correctly - how to update Order with OrderItem
I would like to ask about the concept, so pseudo-code or example in your preferred language should be enough.
Problem:
Let's say, I have two entities. Order and OrderItem. Order has many OrderItems. ...
- 85
0
votes
2
answers
224
views
Query Java doesn't execute
I'm trying to execute a query on eclipse at my Java program, but it always exit with a exception and don't execute the query, I read a lot of posts here but no one of them could help me with this.
...
0
votes
1
answer
228
views
Windows Form App (.NET Framework) CRUD Project, changes successfully saves into DataGridView, but not the actual Database Table
This is my first time using C# and SQL. I've managed to get the datagridview to work, be it insert, update or delete. However, all the changes that is reflected in the datagridview is NOT updating in ...
0
votes
1
answer
52
views
SQL - table having different values for different points in time - best practise?
i'm currently designing a database for logging some values for a specific time horizon. For illustration let's just say that i have a table with the following columns as the primary key:
Name | ...
0
votes
2
answers
163
views
connect static database into my android app
guys I'm a beginner Android development, and I want to create a static database and then connected to my android application my Wishes:
user register from the application and that database should ...
0
votes
2
answers
77
views
Checking sql errors/exceptions
When I use java, I've often seen code like this:
try {
// any CRUD operation
} catch(SQLException e) {
// do some specific database error stuff
// if we're in a transaction, we usually ...
- 2,982
0
votes
2
answers
150
views
crud delete all rows
I'm trying to delete all rows from my database using crud and this is my delete response page.
I tried the query delete * but that didn't work so I've manually typed it up like this. The values are ...
- 19
2
votes
5
answers
895
views
Relational databases - to delete or not to delete? [duplicate]
Iv'e just heard from a colleague that deleting rows on a relational DB is pretty dangerous (regarding indexing and cascading actions)
He said that one solution for allowing deletions is to have a "...
- 6,532
2
votes
3
answers
127
views
update part of the key
Q:
If I have a composite key combined from 4 fields for example, can I update one of them?
I mean can I execute a statement like this:
UPDATE tb
SET firstCol = '15', secondCol = 'test2'
WHERE ...
- 11.4k
-1
votes
3
answers
264
views
What features should a new SQL-based Rapid Development tool have? [closed]
I am interested in developing a new SQL-based RDS which can generate prototype CRUD-oriented 4GL code which can then be easily customized. So I am looking for opinions, suggestions, etc. in what ...
- 2,042