Stack Overflow
Stack Overflow

Questions tagged [database-engine]

57 questions
2
votes
1 answer

Keeping video viewing statistics breakdown by video time in a database

I need to keep a number of statistics about the videos being watched, and one of them is what parts of the video are being watched most. The design I came up with is to split the video into 256 intervals and keep the floating-point number of views…
Septagram
  • 9,425
  • 13
  • 50
  • 81
1
vote
2 answers

Is there a minimalistic graph database?

I am looking for a very basic graph database engine. I only know of Neo4j so far. For my application, nodes are only represented by their string names. They have no further attributes. Connections have start and end nodes and weights. They have no…
danijar
  • 32,406
  • 45
  • 166
  • 297
1
vote
2 answers

MYSQL innodb or myisam? Which one is best for this case?

I'm really lost on which type of database engine should I pick for my table. +-----------------------+ | id | userid | content | +-----------------------+ Imagine this table. userid is holding user ids which are stored in another table. Also, some…
Shaokan
  • 7,438
  • 15
  • 56
  • 80
1
vote
1 answer

Using table locking to prevent multiple users from updating at a given time

I am building a simple shopping cart. Currently, to ensure that a customer can never purchase a product that is out of stock, when processing the order I have a loop for each product in their cart: -- Begin a transaction -- Loop through each product…
Iva
  • 55
  • 3
1
vote
0 answers

Why do I have to keep reinstalling Microsoft Access Database Engine in order for my application to run?

I have a C# Visual Studio application that I publish and install on a different computer, a Windows 10 64-bit OS, x64-based processor. The platform target for the build and publish is x64. The application is actively used and works great for…
user2093192
  • 77
  • 1
  • 7
1
vote
1 answer

Why does LevelDB make its lower level 10 times bigger than upper one?

According to the official document, there is no doubt that lower level is 10 times bigger than upper one in LevelDB. The question is why 10? not 2? not 20? It is due to some rigorous math calculations or it just works? I have read the original LSMT…
LeeLee
  • 158
  • 1
  • 6
1
vote
0 answers

Is it possible to Install only SQL Server database engine without installing SQL Server Management Studio?

I have a Windows application which uses a database on the server. My connection string is something like: con = new SqlConnection("Server=10.100.10.100;Initial Catalog=MyDB; Integrated Security = true"); Is there any way I can only install only the…
Darshan Bharadwaj
  • 37
  • 9
1
vote
1 answer

How to remove Specific Database Engine

I want to completely remove only YE\EZEENEXTGEN Database Engine. Not other server engines.
Ye Htun Z
  • 2,079
  • 4
  • 20
  • 31
1
vote
1 answer

Database-agnostic ASP.NET application?

One of the requirements of the ASP.NET application I'm developing is to be database-agnostic; that is, to be able to talk to an amount of database engines without having to make significant changes to the code. I already know that the first part of…
Léster
  • 1,177
  • 1
  • 17
  • 39
1
vote
2 answers

SQLServer 2012 Installed copy showing problems:

My problem is like this: I had a copy of SqlServer 2012 installed on my machine. It's been there for over 3 years without any glitches at all. Just 4-5 days ago, a problem sprouted up. When I started Management Studio it told me that msdb got…
PGC Choudhury
  • 45
  • 1
  • 9
1
vote
1 answer

Please tell me how to create a SQL Server 2008 R2 Database Engine on my local Desktop computer

I already have SQL Server 2008 R2 installed on my local Desktop computer. We use it to connect to Remote SQL Server 2008 Database Engines in the network. However, for development purposes, I would like to create a SQL Server 2008 R2 Database…
crazyTech
  • 1,379
  • 3
  • 32
  • 67
1
vote
1 answer

Issue converting table from InnoDB to MyISAM (there can be only one auto column and it must be defined as a key)

I'm having issues trying to convert a table from MyISAM to InnoDB in MySQL 5.6. The following is the table dump: -- -- Table structure for table `companies` -- DROP TABLE IF EXISTS `companies`; /*!40101 SET @saved_cs_client =…
Francisco Zarabozo
  • 3,676
  • 2
  • 28
  • 54
1
vote
3 answers

Which DB type would be more suitable for high performance purposes?

I'm looking to design a system that has the following data capabilities: Multiple sources high writing rate, 50K - 100K of records per second (from ). Single source fast reading, single IO fetch operation. This is basic DB table/set design: Type…
Eran Betzalel
  • 4,105
  • 3
  • 38
  • 66
1
vote
2 answers

best engine for high-performance counts table

I have a counts table which contains columns similar to (around 14 count columns): user_id friends_count photo_count video_count blogs_count This table gets updated whenever the user adds a photo or a friend. I am going with InnoDB Engine since it…
Bujji
  • 1,717
  • 10
  • 41
  • 66
0
votes
1 answer

Snowflake sqlalchemy python cant connect because of getaddrinfo failed inside virtual machine of company network

I need to read and write some data to a snowflake databse. I have the credentials and everything is working fine on my local pc. But in the virtual machine of the company I am doing this I get this I think its a proxy problem but i dont know what to…
Barathan
  • 21
  • 1
1
2
3 4