Recent questions tagged Database

0 votes

968 views

1 answer

database design - How many records can I store in 5 MB of PostgreSQL on Heroku?

I'm going to store records in a single table with 2 fields: id -> 4 characters password_hash -> 64 characters ... it will take in a database? See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

database - compilation of Ormliteconfig file in Android studio

Can anyone guide me how to compile OrmLiteConfigUtil file in AndroidStudio i'm new to both ormlite and Android ... is still giving the exception See Question&Answers more detail:os...

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

0 votes

818 views

1 answer

database - How can we share a backend MS Access 2016 on One Drive

We operate a small retail business with three retail shops. Each shop has it's own PC running Windows ... looking at something like SharePoint? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - How to calculate size of the one record in hive?

I need to understand how much memory my table will use. I know the arithmetic mean of records. I know what ... size of every column of record? See Question&Answers more detail:os...

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

0 votes

916 views

1 answer

database - Getting an ORA - 00907 error on the following at ON UPDATE

When implementing my oracle database I receive an ORA-00907 error on line 8 at ON UPDATE. Its complaining about right ... 0 AND Jweight < 116)) See Question&Answers more detail:os...

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

0 votes

815 views

1 answer

database - magento upgrade from 1.6.2 to 1.7.0.2 - Will the db base be changed?

i am looking into upgrading my magento community from 1.6.2 to 1.7.0.2. First i will do this on my ... last question, which lines are changed? See Question&Answers more detail:os...

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

0 votes

898 views

1 answer

database - trying to concat in the RAISE() function using || results in a syntax error

relevant documentation I am trying to create a trigger that catches inserts into the Viewings table where the foreign key ... table.') END; END; See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database - Using execSQL for INSERT operation in Android SQLite

From the documentation and this post I know execSQL() executes a single SQL statement that is not a SELECT ... SELECT statement attached to it? See Question&Answers more detail:os...

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

0 votes

901 views

1 answer

database - How do I change a MySQL table to UTF-8?

I know there are many settings for a language for a table and a database. I already created the database. I believe ... can I do that? thanks. See Question&Answers more detail:os...

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

0 votes

801 views

1 answer

database - How to get substring in SQLIte?

I retrieve quite a lot of data from SQLite database. When retrieving I map it to different views in ... the substring from description? thanks See Question&Answers more detail:os...

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

0 votes

756 views

1 answer

database - understanding mysql explain

So, I've never understood the explain of MySQL. I understand the gross concepts that you should have ... `yourock_achievement`.`modified` DESC See Question&Answers more detail:os...

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

0 votes

864 views

1 answer

database - Performance of LIKE queries on multmillion row tables, MySQL

From anybody with real experience, how do LIKE queries perform in MySQL on multi-million row tables, in terms of ... 'title' LIKE '%query%' See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

database design - What is the recommended equivalent of cascaded delete in MongoDB for N:M relationships?

Assuming the following "schema/relationship" design what is the recommended practice for handling deletion with cascade ... this one out. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - MySQL Workbench drops connection when idle

I'm using MySQL Workbench 6.3 on my OS X 10.9.5 to manage several cloud databases (hosted on Rackspace), ... anybody have a solution for this? See Question&Answers more detail:os...

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

0 votes

891 views

1 answer

database - How does MySQL store data

I looked around Google but didn't find any good answers. Does it store the data in one big file? What methods ... and writing to a regular file? See Question&Answers more detail:os...

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

0 votes

835 views

1 answer

database - how to get current datetime in SQL?

Want to get current datetime to insert into lastModifiedTime column. I am using MySQL database. My questions ... function available in MySQL? See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

database - Why restrict the length of a password?

I've just signed up to a site to purchase some goods, and when I tried to enter my (reasonably secure) ... were your reasons for the decision? See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

database - Basic data storage with Python

I need to store basic data of customer's and cars that they bought and payment schedule of these cars. These ... you advice me to another way? See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

database - Why don't you start off with a "single & small" Cassandra server as you usually do it with MySQL?

For any website just starting out, the load initially is minimal & grows with a slow pace initially. People ... LAMP stack on single server. See Question&Answers more detail:os...

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

0 votes

857 views

1 answer

database - Unable to connect to SQL Server instance remotely

I'm trying to access the SQL Server instance on my VPS from SQL Server Management Studio on my local machine ... login using that! Thanks again! See Question&Answers more detail:os...

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

0 votes

970 views

1 answer

database design - MySQL: bigint Vs int

I have been using int(10) and just noticed that Wordpress uses bigint(20) - What is different to use ... NOT NULL AUTO_INCREMENT, Thanks. See Question&Answers more detail:os...

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

0 votes

796 views

1 answer

database design - is my data normalized?

I'm making a simple quiz database, where a question has an answer and one or more image files, and belong ... used in other questions. Thanks. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

database - How Do I Trim Leading and Trailing Quote from MySQL Row?

I have a MySQL table that I have imported from a CSV file. In this process, a bunch of the entries ... leading quotation marks from the row? See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

database - How to change the output folder for migrations with asp.net Core?

Does anyone know how to change the output directory of the following command? dotnet ef migrations add Initial ... migrations to be separated. See Question&Answers more detail:os...

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

0 votes

994 views

1 answer

database - Performance of large EAV/open schema systems on SQL Server

Has anyone implemented a very large EAV or open schema style database in SQL Server? I'm wondering if ... able to overcome those obstacles. See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

database - DAO and JDBC relation?

I know that Hibernate implements ORM (Object Relational Mapping), what type of mapping does JDBC implement? Does it ... related to JDBC...? See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

database - Using map reduce in CouchDB to output fewer rows

Lets say you have two document types, customers and orders. A customer document contains basic information like name, ... reduce is the way? See Question&Answers more detail:os...

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

0 votes

988 views

1 answer

database - Tree structure data query in SQL Server

I have a table Person that has 3 columns: Id, Name, ParentId where ParentId is the Id of the parent ... design for my table/database? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags