Database
A database is a structured set of data held in a computer, most often a server. Databases use a database management system (DBMS) that interacts with users, similar to a lookup table. Modern databases are designed to allow for creation, querying, updating, and administration of the data it holds.
Here are 13,226 public repositories matching this topic...
Feature Request
Is your feature request related to a problem? Please describe:
This is a really minor nit, but the EXPLAIN output on binary strings is different from what I expected:
CREATE TABLE t1 (
id INT NOT NULL PRIMARY KEY auto_increment,
b varchar(255) not null,
c varbinary(255) not null,
index (b),
index (c)
);
INSERT INTO t1 (b,c) VALUES ('a', 'a'),('b
const XLSX = require('xlsx');
const wb = XLSX.utils.book_new();
const ws = XLSX.utils.json_to_sheet([]);
XLSX.utils.book_append_sheet(wb, ws, 'Bug sheet');
ws.A1 = { t: 's', f: 'square' };
XLSX.writeFile(wb, 'formula.ods');
The resulting .ODS file contains:
<table:table-cell table:formula="of:=square" office:value-type="string"><text:p>undefined</text:p></table
When adding a new data store database in Metabase it tries to connect first with SSL (if the driver supports SSL), and then without, in that order. If either connection succeeds, the database details are accepted as valid. Yes, you can add driver specific JDBC options to use SSL, but there is no good feed
Issue type:
[x] question
[ ] bug report
[ ] feature request
[x] documentation issue
Database system/driver:
[ ] cordova
[x] mongodb
[ ] mssql
[ ] mysql
/ mariadb
[ ] oracle
[ ] postgres
[ ] cockroachdb
[ ] sqlite
[ ] sqljs
[ ] react-native
[ ] expo
TypeORM version:
[x] latest
[ ] @next
[ ] 0.x.x
(or put your version here)
Right now we have the following, which doesn't validatie the needs of a given view. This allows for any colors to be provided, not necessarily the ones that are required. I'd recommend making these color validations accurate, where for Gauge
it would require the min
and max
for instance. I'm assuming these are required for gauge, that may be in error. Would be nice to provide swagger that p
In PostgreSQL, @ is a unary operator that returns the absolute value of a number. For example:
jordan=# select @ -5.0;
?column?
----------
5.0
(1 row)
CockroachDB is missing such a unary operator.
-
Updated
Jul 1, 2020 - Python
Describe the bug
Any attempt to test a subscription directly to the Prisma server via Playground returns the following error:
The provided query doesn't include any known model name. Please check for the latest subscriptions API.
In review of the WS transactions in the browser console, I can see I am receiving this response from the Prisma endpoint, but nothing is being logged by Pri
Environment
- PostgreSQL version: All
- PostgREST+ version: 6.0.2 (713b214)
Current state
Currently, Comment on Table
COMMENT ON SCHEMA todos IS
'Todos object description';
generate a summary for all operations on this resource
/todos:
get:
tags:
- todos
summary: Todos object description
parameters:
But sum
Sometimes it is needed to store compressed data in the DB. Unfortunately not all the DBs have built-in compression and FUSE compressed FSes are not available for every OS. So it may make sense to store compressed binary blobs in the DB.
Unfortunately when one sees them in DBeaver he sees them compressed, but often they are needed uncompressed. So it'd be nice to have a feature to decompress the
Phase 2:
[x] custom_data incl bson support
[x] functions
[x] remote mongodb client
[ ] push
Details of above subtasks are described in this doc
-
Updated
Jul 3, 2020 - TypeScript
Experience Report
I am currently ingesting a large continuous streaming data set. The most recent data is the most important data. The oldest - either by policy or by least importance needs to be aged-off. Today, we use Neo4J Community Edition. We perform a query to find nodes/relationships older than a specific date and then delete them.
Note: Feature requests are judged based on user
Your documentation shows no way to replace an objects value. Any updates to an object with:
db.get(name).find(selectors).assign(data).write()
merges the data with the existing object...not what I'd expect.
How can we replace a record without merging? Can you update your docs?
Issue
Per MongoDB specification, to query if the array field contains at least one element with the specified value, use the filter { <field>: <value> }
where <value>
is the element value and <field>
the a field in the document that contains an array as value.
Info
- Environment: browser
-
Updated
Apr 19, 2020 - C++
-
Updated
Jul 2, 2020 - JavaScript
I'm looking at the react tutorial at https://github.com/amark/gun/wiki/React-Tutorial and noticed that the code examples are using depreciated lifecycle methods such as componentWillMount.
超级表STable的删除有方便的办法吗?
必须先将通过STable创建的表先删除,然后才能删除超级表。当级联表很多时就麻烦了,除非写代码来删除。
Throw NullPointException when INSERT column and values mismatch.
It is better to throw suitable SQLException for JDBC-driver and proxy.
The tasks are:
- Throw suitable SQLException for JDBC-driver.
- Report suitable error packet with MySQL proxy.
- Report suitable error packet with PostgreSQL proxy.
The encryption section in Java docs https://realm.io/docs/java/latest/#encryption leads to an example that doesn't properly provide a best practice solution for how to store keys used for encryption.
On a sharded collection, if you try to create a custom index (e.g. hash index) with uniqueness, that doesn't include the sharding key (which by default is the autogenerated _key
) then it will fail with an error like:
Index creation failed: shard key '_key' must be present in unique index
There's zero documentation that I could find around this, and it's fairly fundamental, since you can't
Feature request description
For now the only way to add TLS validation is though code with RegisterTLSConfig. With providing certificate path though DSN (like pq is doing it) all existing applications will receive TLS certificate validation out of the
I am running a sample test in SqlServer where it is using ToString() on a string column (COL2) in the LINQ.
The test is giving following error when trying to generate SELECT query from the LINQ.
**Unhandled exception. System.InvalidOperationException: The LINQ expression 'DbSet
.Where(t => t.COL2.ToString().Contains(__url_0))' could
-
Updated
Jun 12, 2020
Is there a plan to add a CONTRIBUTING.md? This could include template to do a PR, guidelines to add tests, coding standards, etc.
I'm currently learning Rust and am very interested in contributing on this project somehow. Thanks!
- Wikipedia
- Wikipedia
I'm using TLS on etcd 3.3.12 and have a mix of etcd proxies and masters. The proxies don't seem to honour the --cipher-suites setting, as it ends up with
ECDHE-RSA-AES256-GCM-SHA384
despite--cipher-suites=TLS_ECDHE_RSA_WITH_CHACHA20_POLY1305,TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256
being set.