All Questions
87
questions
2
votes
1
answer
896
views
Timeseries database with concurrent update of historical data
I need to store timeseries data, and have special requirements. Lets say that I want to store the turnover for my business for every 5 minute-interval. E.g one timeseries
Store#1
1/12–2016 10:00–10:...
0
votes
1
answer
147
views
How can i update my database column name from laravel 5.3 artisan
i tried with this
php artisan make:migration update_username_field_to_users_table
but it didn't work and give an error.Let me now about the process i should follow.
0
votes
2
answers
744
views
Updating record in phpmyadmin with php code
I have a reservation form where once it is filled out, the rooms available for a certain building are decreased by one. I am using Cloud9 ide with php to update the record for that building in the ...
0
votes
2
answers
1k
views
Excel VBA to Access database: Decimal number issue
I am working on a small Access DB where I add row values as 1.1, 2.1, 3.1 from an Excel file. When I update, this is getting updated as 1.0999999999, 2.0999999999,3.1000000000000001 in the Access DB. ...
-1
votes
1
answer
79
views
how to write a c# form application that can be updated in future(by instaling updated code or file)
Let say i have publish an Windows form application which has 2 labels and 2 text field(Name, Email) ,a SAVE button and a button name UPDATE (file selector).Again let say i have two method in my ...
0
votes
1
answer
76
views
What is the best database solution to store large often updated datasets?
I have a MySQL table with dataset > 50 M rows and counting.
There are many updates and inserts that are taking more and more times (data set is increasing) so I am worried that it will be a ...
0
votes
0
answers
67
views
Postgres - go - how to find last updated database in Postgres?
I am having more than 100 database. Each database contains some tables. After performing some operation tables in database got updated. Currently am running a thread which will connect each database ...
0
votes
2
answers
81
views
Django - Update each field in the database that have this value
Let's say I have two tables:
table#1: Space
table#2: Students
If I want to change the prom_name form table#1, I'd like to automatically update the prom_name in my table#2 as well
My model Students ...
0
votes
3
answers
118
views
How to efficiently store temporary userdata
I'm fairly new to Java and I need help with something. Is there an (efficient) solution to the following problem:
I have a bot where players can "roll" to gain coins. Right now, after every single ...
1
vote
2
answers
90
views
Django: Update or Change previous saved model data
I have this code in my forms.py
ref_user = User.objects.get(
username=form.cleaned_data['referrer']
)
user = User.objects.create_user(
username=form.cleaned_data['username']
)...
2
votes
4
answers
74
views
UPDATE and SELECT
Why do I need the SELECT privilege on this:
UPDATE Sailors S SET
S.rating = S.rating - 1
While I don't need it for this query:
UPDATE Sailors S
SET S.rating = 8
1
vote
2
answers
270
views
Store user data in database separately
What is the best practice to store user data separately from the actual app data? The user data is a statistic and it will be collected during app usage. The database must be always updated but I have ...
1
vote
2
answers
32
views
Sql Server Update Rows where like '%#186;%'
Hello I have in my database a bunch of table rows that contain the following values:
Street Number 1095 - 4º Esqº
and I am trying to remove
º
from all the rows that ...
0
votes
1
answer
73
views
Couchbaselite update operation leads to inconsistent behavior
I am using Couchbase Lite SDK for android and saving an object instance of MyClass as a document in the database. MyClass has an attribute that stores the date in the java.util.Date. During run time, ...
0
votes
1
answer
135
views
Is it safe to append some data at end of the binary firebird database file?
My main intent is to add some version information to a Firebird database file, since I will use Firebird as embedded database and installers/update mechanism will need this information.
The ...