Stack Overflow
Stack Overflow

Questions tagged [database-engine]

57 questions
0
votes
0 answers

Sorting tuples with divide-and-conquer algorithm inside DB

I saw a lecture explaining that the database engine uses the divide-and-conquer algorithm for sorting to split the data set into separate runs and then sort them if the data that we need to sort couldn't fit in memory. In this algorithm when the…
Mohammed Ismail
  • 15
  • 1
  • 5
0
votes
0 answers

Is it possible to do a outer apply on two tables from different database engines to get unmatched records?

I am trying to find records that are in table C but not in table M in a column called records. I am doing an outer apply but the query does not finish executing. It does not give any errors. The two tables are in different database engines. I am…
Pauli du Plooy
  • 21
  • 4
0
votes
2 answers

Django support for asynchronous database engines

I can't find information about django support for asynchronous database engines. For example for postgresql django supports only psycopg2 library, that is completely synchronous and nothing more is supported, for sqlite django supports only sqlite3…
user19068550
0
votes
0 answers

How to calculate the distance of one string across a defined range of strings?

Given an interval defined by two strings, [x, y], and third string s between them, is there a way to calculate the percentage of the whole interval from x to s. Preferably which honors collation (case matters vs not, for instance). An approximate…
Joel
  • 5,618
  • 1
  • 20
  • 19
0
votes
1 answer

Creating a variable for each key value pair in JS

I have a problem... I have a string that inputted by the user and looks something like this let conditions = "id === 101 || name === 'Albert' && age !== 43" I also have an array of data that was also created by the user at some point previously The…
Dark Programmer
  • 482
  • 3
  • 6
  • 18
0
votes
1 answer

How do i design a schema with proper DB engine to accumulate data depending on this need on clickhouse or in any other database?

We're a new Adtech company and I was planning to design a database where I'll pull all the data to a single table and then make new tables with a materialized views for others to generate multiple reports. Say we have Inventory, impression, views…
Aniruddha Chakraborty
  • 1,849
  • 1
  • 20
  • 32
0
votes
0 answers

How to run Microsoft Office Version : 18.2008.12711.0 with accessdatabaseengine_X64 in .NET Framework 4.8?

I am a newbie to this platform and also to running MS Office applications with .Net. I am trying to export data from datagridview to excel sheet on click of a button. Here's my code : Dim xlApp As Microsoft.Office.Interop.Excel.Application Dim…
Rashmi Gupta
  • 3
  • 2
0
votes
2 answers

Which database engine type should be specified for Microsoft SQL Database in Laravel?

I am working on a web application using OctoberCMS which sits on Laravel 5.5.40 and is using a Microsoft SQL Database. Database migrations are managed using the standard Blueprint objects which allow a database engine to be specified. Currently all…
Richard
  • 422
  • 7
  • 17
0
votes
0 answers

Not able to read data from excel using OLEDB

I got a code in which it is trying to read data from excel using OLEDB and populate the same into grid view. The grid was not populating with the values as desired. I debugged the code and I am getting a message like this. enter image description…
NIDHIN SANKAR
  • 13
  • 3
0
votes
2 answers

Connect to Database Engine through query

When you open the SQL Server Management studio you connect to the Database engine through UI.I want same functionality through SQL query e.g. to connect to database we write Use similarly is there any way to connect to database engine.
meetjaydeep
  • 1,752
  • 4
  • 25
  • 39
0
votes
0 answers

Setting database engine collation during SQL Server installation

I want to install SQL Server but I don't want to use default database engine collation defined during setup(there is polish collation). I know how to change it during setup but I need clear English (which is not on the list). It is safe to install…
Redzix
  • 170
  • 3
  • 15
0
votes
1 answer

ndbCluster and Azure

I'm currently working in a big project where we need to use a ndb cluster engine in an Azure environment (project constraints). I have already read the paper "Set up a MySQL IaaS NDB cluster with 4 nodes on Azure Linux" but i did not manage to find…
M.ferlay
  • 47
  • 1
  • 5
0
votes
1 answer

Include Microsoft Office Access database engine 2007 to installer with InstallShield Limited Edition

How can I include Microsoft Office Access database engine 2007 (https://www.microsoft.com/en-us/download/details.aspx?id=23734) to installer with InstallShield Limited Edition?
chinh nguyen van
  • 729
  • 2
  • 7
  • 18
0
votes
3 answers

Database and DB engine for social website

For a heavy user content website with user profiles, live feeds, photo /video/content sharing, etc what DB to use, and what DB engine? Ofcourse Oracle/Microsoft sql are out because they are not free (or cheap). I am using MySQL with MyISAM but that…
kor65
  • 9
  • 1
0
votes
2 answers

Is There A Database Engine that Allows for Queriable Field Constraint Specified by RegEx?

I'm looking for a database engine that can handle data constraints specified via RegEx. So in addition to the datatype, I want to be able to control the format of the data. E.g. a varchar(255) field could be further restrained to be like [a-zA-Z0-9…
James Oravec
  • 19,579
  • 27
  • 94
  • 160
1 2
3
4