Questions tagged [database]
A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views, and other objects. The data is typically organized to model aspects of reality in a way that supports processes requiring information. Use this tag if you have questions about designing a database. If it is about a particular database management system, (e.g., MySQL), please use that tag instead.
database
60,091
questions with no upvoted or accepted answers
14
votes
2
answers
8k
views
Android Room Database: How to embed multiple entities
I am using room for my new project, but I am struggling with how to access one-to-one values cleanly
I have entities for addresses, owners and sites, both owners and sites have an associated address, ...
14
votes
3
answers
3k
views
SQLAlchemy: What is the best way to validate a model before inserting or updating
I'm trying to validate a SQLAlchemy model before it is inserted or updated, e.g
class MyModel(db.Model):
foo = db.Column(db.String(255))
bar = db.Column(db.String(255))
I've tried a few ...
13
votes
1
answer
522
views
Render jquery datatable inside React-pivottable
I have implemented react-pivottable just wanted to know is there a way to display the entire data set in jQuery data table view
i.e, I have a few columns want to display all of them in a tabular ...
13
votes
0
answers
2k
views
How to manage offline data in android like facebook and instagram does
I know similar question has been asked here .but they only answered image caching perspective.So My request is to please go through whole question before announcing it duplicate .
My question is :
...
13
votes
0
answers
4k
views
Postgresql: partial foreign key?
Is it possible to create a partial foreign key (similar to partial indexes) in general sql / postgresql? I have not found a way to force referential integrity in the following case:
Table A is soft-...
12
votes
2
answers
6k
views
android room database locked
I had been getting " android.database.sqlite.SQLiteDatabaseLockedException" exception from production when I had been using 3rd party non-thread safe sqlite libraries. I checked all the threads and ...
11
votes
2
answers
229
views
Azure Recovery Services and SQL 2014 Managed Backups not playing well together
I started using Managed Backups on my SQL server. It has been working well for over a year. It seems to backup the dbs once a week, and take incrementals every 2 hours.
A month ago, we changed our VM ...
11
votes
1
answer
3k
views
EF 6 - Error Exception calling SetData with 2 argument(s)
I have a solution with multiple projects. The DBContext file and Models are in a ClassLibrary project. This project has EF 6.1.3 and it is running on .NET 4.5.2. The models and DBContext files are in ...
11
votes
0
answers
22k
views
Failed to set EGL_SWAP_BEHAVIOR on surface 0xb14ae7a0, error=EGL_SUCCESS
I dont know why it isn't working. It doesnt matter what I write on the edit text it always says the same thing: "THE NAME "+NAME+"ALREADY EXIST". I just dont know what the problem is.
public class ...
11
votes
1
answer
2k
views
Speed up sqlFetch()
I am working with an Oracle database and like to fetch a table with 30 million records.
library(RODBC)
ch <- odbcConnect("test", uid="test_user",
pwd="test_pwd",
...
10
votes
0
answers
582
views
Knex.js batch insert handle onConflict merge
I had a case where I was saving 1800 rows at once and as the data grow it started to cause some issues. Then I started to use .batchInsert() which was working properly. Now I have to handle conflicts ...
10
votes
0
answers
533
views
Why Visual Studio's Database Profiler shows "unknown" results?
I'm trying to use Visual Studio's Database Profiler following Microsoft's documentation.
Everything seems to work as described but in the report, I get unknown values, except very few queries (4 out ...
10
votes
2
answers
14k
views
Missing comma before start of a new alter operation. (near "CHARACTER SET")
Mysql - phpmyadmin
What's wrong with this query?
ALTER TABLE `invoices`
CHANGE `status` `status` ENUM('paid','due','canceled','partial','cheque')
CHARACTER SET `utf8` COLLATE `utf8_general_ci` NOT ...
10
votes
0
answers
696
views
How can I get a _raw stream_ of bytes being stored in a database?
I have the following database, written in some variant of MS Access (it's an MDB file -- UNIX file confirms this)
I'm trying to read the contents of from Javascript in Windows. Though, really, any ...
10
votes
0
answers
11k
views
Effect of fetchsize and batchsize on Spark
I want to control the reading and writing speed to an RDB by Spark directly, yet the related parameters as the title already revealed seemingly were not working.
Can I conclude that fetchsize and ...