Recent questions tagged database

0 votes

1.3k views

1 answer

database - How can I solve Postgresql SCRAM authentifcation problem?

I am getting an error after moving the project to production. The error is as follows while running with production server ... .8.5-36), 64-bit See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

database - Convert String ISO-8601 date to oracle's timestamp datatype

I have a ISO-8601 date in VARCHAR2 type, how can i convert that String date to timestamp in oracle db? Date Example: ... :00', ????) FROM DUAL See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

837 views

1 answer

database - Does MongoDB support floating point types?

I am migrating a mysql database to mongodb. But i have read in MongoDb data types and then there is no reference to ... i do or what can i do? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

811 views

1 answer

database - SQL LIKE operator in Cloud Firestore?

I have been using Firebase Real Time Fatabase for a while and I come across Cloud Firestore today. I can't figure ... ); But it doesn't work. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

660 views

1 answer

database - Personal names in a global application: What to store

Storing personal names in a structured way seems quite difficult when it comes to an application which is used by ... have a complex structure. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

874 views

1 answer

database - Java PreparedStatement UTF-8 character problem

I have a prepared statement: PreparedStatement st; and at my code i try to use st.setString method. st. ... i solve this problem? Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

685 views

1 answer

database - How universal is the LIMIT statement in SQL?

I'm in the process of generalizing a Django DB replication app and it uses the statement: SELECT %s FROM ... platform is the LIMIT statement? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

729 views

1 answer

database - How to make a UUID in DynamoDB?

In my db scheme, I need a autoincrement primary key. How I can realize this feature? PS For access to DynamoDB, ... dynode, module for Node.js. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

621 views

1 answer

database - What is the best way to do incremental backups in MySQL?

We are using MySQL version 5.0 and most of the tables are InnoDB. We run replication to a slave ... practices when doing incremental backups? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

765 views

1 answer

database - Strange behavior in PowerShell function returning DataSet/DataTable

This is driving me crazy. I have a library I source from multiple scripts, which contains the following function: ... can't figure out what. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.0k views

1 answer

database - Spring Batch Framework - Auto create Batch Table

I just created a batch job using Spring Batch framework, but I don't have Database privileges to run ... writer and processor work properly. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

600 views

1 answer

database - android sqlite bidirectional synchronization sqlite

I need to sync my Android SQLite DB with my cloud-server DB, and doing it in a bi-directional way in ... read about a better solution/algorithm. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

711 views

1 answer

database - Delivery of JMS message before the transaction is committed

I have a very simple scenario involving a database and a JMS in an application server (Glassfish). The scenario is ... is really used. Any idea? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

750 views

1 answer

database - What are the main differences between Redis Pub/Sub and Redis Stream?

What are the pros and cons of each? Please advice when to use one and not the other. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

873 views

1 answer

database - In SQL Server, how can I lock a single row in a way similar to Oracle's "SELECT FOR UPDATE WAIT"?

I have a program that connects to an Oracle database and performs operations on it. I now want to ... of redundant and unnecessary accesses. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

563 views

1 answer

database - Spring data : CrudRepository's save method and update

I wanted to know if the {save} method in CrudRepository do an update if it finds already the entry in the ... a changed attribute ? Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

570 views

1 answer

database - Spring data : CrudRepository's save method and update

I wanted to know if the {save} method in CrudRepository do an update if it finds already the entry in the ... a changed attribute ? Thanks. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

765 views

1 answer

database - What is the default Precision and Scale for a Number in Oracle?

When creating a column of type NUMBER in Oracle, you have the option of not specifying a precision or scale. What ... if you don't specify them? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

711 views

1 answer

database - How to recover just deleted rows in mysql?

Is it possible to restore table to last time with data if all data was deleted accidentally. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

599 views

1 answer

database - How to get from a MySql server to an Android app?

I have a MySql database with some sports results in it. I want to write an Android application to display these ... display some of the data? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

767 views

1 answer

database - What is the point of "Initial Catalog" in a SQL Server connection string?

Every SQL Server connection string I ever see looks something like this: Data Source=MyLocalSqlServerInstance;Initial Catalog= ... 's it for? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

652 views

1 answer

database - How to implement Active Record inheritance in Ruby on Rails?

How to implement inheritance with active records? For example, I want a class Animal, class Dog, and class ... the database table mapping be? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

733 views

1 answer

database - When to close db connection on android? Every time after your operation finished or after your app exit

I have an android application that access local sqlite3 db frequently, for performance consideration so i always keep the ... size of the DB ? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

887 views

1 answer

database - CodeIgniter - return only one row?

At the moment if I am doing a query on the database that should only return one row, using: ...query ... directly. e.g. $query->campaign_id; See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

561 views

1 answer

database - SQL: Using NULL values vs. default values

What are the pros and cons of using NULL values in SQL as opposed to default values? PS. Many similar ... but none answer my question. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

588 views

1 answer

database - Conditional logic in PostDeployment.sql script using SQLCMD

I am using a SQL 2008 database project (in visual studio) to manage the schema and initial test data for my ... that the path is incorrect. See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

765 views

1 answer

database - how to use Blob datatype in Postgres

I am using a Postgresql database in my rails application. To store large file or data in database I have used ... use instead of blob in MySql? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

841 views

1 answer

database - Django's ManyToMany Relationship with Additional Fields

I want to store some additional information in that, automatically created, ManyToMany join-table. How would I do ... this the best approach? See Question&Answers more detail:os...

asked Oct 17, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags