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
195,298
questions
-4
votes
1
answer
37
views
Deleting item from sqlite database have error [closed]
Deleting item from sqlite database error.
CustomAdapter
public class PassAdapter extends RecyclerView.Adapter<PassViewHolder> {
Context context;
MainActivity mainActivity;
private ...
-2
votes
0
answers
22
views
Creating a power app that displays a pdf viewer of a floorplan? [closed]
Have little experience in this and no idea where to start.
I’m looking to create a power app with Split View. Left side for viewing a floorplan either in .pdf or .dgn (Bentley microstation). I’d like ...
-4
votes
0
answers
10
views
my question is create a menu given program wit the following option
1 Add in voice.
2. Display in voice.
3.Search in voice
4.Delete in voice.
5 exit
Once user enter the option 1 you need to ask the following detail from the user
Invoice number.
Custmor name.
...
0
votes
2
answers
72
views
How To Import a Big .csv(~2GB) Into a PostgreSQL Table
I am new into databases and PostgreSQL and today I wanted to import this dataset: https://www.kaggle.com/datasets/wilmerarltstrmberg/recipe-dataset-over-2m/data into a PostgreSQL so I can make a ...
0
votes
1
answer
23
views
Error while trying to migrate data from one table to another in BigQuery
I run into a problem when trying to migrate data between BigQuery tables, I have an old table that has an attribute nested as Float64, I want to migrate the data from this old table, to another one, ...
-1
votes
0
answers
12
views
Database inspector in Android studio show nothing
I use Drift as my database, currently I need to visualize the data to fix bugs in the project.
After I connected the emulator and the application, it said there's nothing to show in the database ...
0
votes
1
answer
26
views
Postgres serializable isolation level confusion
I'm learning about database isolation levels and I'm attempting to walk through an example of when the serializable isolation level would cause concurrent transactions to error.
I have come up with ...
0
votes
0
answers
31
views
MariaDB 10 -> 11 migration, the 11th version stopped using possible_keys
I faced the issue during migration from MariaDB 10.11 to 11.0 version that some specific queries run longer.
During running EXPLAIN output I got this.
MariaDB 10.11
MariaDB [my_schema]> EXPLAIN ...
0
votes
0
answers
38
views
i dont know how to display the discussion according the id [closed]
as the title said, I already changed a lot of code but I also cannot display the discussion that users who post by themselves according to user_id in my discussion database. I can display all the ...
0
votes
0
answers
21
views
Approach to Save external data and Update when data changed [closed]
I am using dotnet EF CORE to save some external data into my database.
I would send serval HTTP Requests to a external endpoint regularly. The program will check if the incoming data has been changed ...
-3
votes
0
answers
25
views
How do I Download Metagenomics Data from NCBI or EBI with its Metadata? [closed]
Hello everyone,
I am currently working on a research project that requires analyzing metagenomics data. I want to download metagenomic sequence data using a command line such as Linux and the ...
-1
votes
1
answer
9
views
Connect PieCloudDB to Tableau: Driver cannot be found
[Question posted by a user from PieCloudDB Community]
I am trying to connect PieCloudDB database to Tableau for some exploratory data analysis, but I kept getting an error that the driver cannot be ...
-2
votes
0
answers
52
views
Database programming with Delphi [closed]
so at my intern im learning delphi and i am supposed to be somewhat good at using mysql and delphi together to make apps. my intention is to learn delphi amd be able to use it to some degree but i ...
0
votes
0
answers
31
views
SQLAlchemy async Records are not added to the association table
Please tell me what I'm doing wrong.
There is this code. Tables are created, model tables
are filled, everything works. But records are not added to the association table.
The code completes without ...
0
votes
2
answers
51
views
.NET / EF Core CRUD The database operation was expected to affect 1 row(s), but actually affected 0 row(s);
I'm creating a new project trying to use Generics as much as possible, but I've encountered an issue when doing HttpPut and using EF Core.
I'm using SQL Server in a container to store temporary data.
...