SQL

SQL stands for structured query language. It uses commands such as "select", "insert", "update", "delete". Some common relational database management systems that use SQL are: Oracle, MySQL, Microsoft SQL Server, PostgreSQL, etc.
Here are 11,525 public repositories matching this topic...
Implement ST_Centroid
on arguments {geography,bool}, which should adopt PostGIS behaviour.
For Geography builtins, please do the following:
- Ideally add a relevant helper function in
pkg/geo/geogfn
(parse and output related functions can go in [pkg/geo
](https://github.com/coc
Document : https://osquery.io/schema/4.2.0
Table : md_devices [Software RAID array settings]
Column's :
- active_disks | INTEGER | Number of active disks in array
- failed_disks | INTEGER | Number of active disks in array
- spare_disks | INTEGER | Number of active disks in array
4.check_array_progress | TEXT | Progress of the resync activity
5.check_array_finish | TEXT | Estimated dur
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
We consider to introduce the SqlSessionManager
on reference documentation. It provide thread safe implementation of SqlSession
.
Related issues
- #1529
Based on comments like this i suggest a compatiblity matrix in the readme under the section Will Dapper work with my DB provider?.
This way new users can get some heads-up before investing time and effort. Especially Microsoft.Data.Sqlite
Environment
Knex version: 0.20.10
Database + version: Postgres 12
Bug
- Explain what kind of behaviour you are getting and how you think it should do
knex.raw("?", [
knex.insert({ id: "b", fields: { a: undefined } }).into("test"),
])
- Error message
Hi guys, welcome!
Background
ShardingSphere 5.x will present itself with new valuable features and simple configuration API to our community.
We will provide many of build-in sharding algorithms to users, which means uses can choose a proper one from sharding-algorithm selections before implementing the interface of the sharding algorithm themselves.
**Therefore we call for
We have a value_at_quantile
function for QDigest types. Occasionally, it's useful to also retrieve a quantile given a value (say, for X, which percentile in the QDigest does it fall under).
The signature would look like the following:
quantile_at_value(qdigest(T), DOUBLE) -> T
Where T is one of DOUBLE
, REAL
or BIGINT
.
Use case
ClickHouse/ClickHouse#7971
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
-
Updated
May 22, 2020 - Java
We are suddenly running out of background workers and were told on Slack to increase timescaledb.max_background_workers
from 8 to 16.
The documentation makes it seem like the timescaledb-tune tool will automatically set the key to a correct value. However the tool [always sets the value to 8](https://github.com/timescale/timesca
I have been testing q and I've found something that could be an issue.
Issue
When I'm doing something like round(avg(c3),3)
when querying, is rounding this 32655,5265 to this 32655,526 instead of expected result: 32655,527.
I think that could be an issue, or should be configurable.
Cheers.
We already have most of our Directus API 2.x endpoints/params within Paw for testing. We could finish adding all of these and then potentially use their code generators to create SDKs for our secondary languages.
https://paw.cloud/docs/extensions/create-code-generator
We also have a Swagger file for 98% of API 1.1 — so we could update that (and make sure that OpenAPI allows for our filteri
The on-line demo at http://kripken.github.io/sql.js/examples/GUI/ does not give error messages (for wrong SQL or missing tables or attributes).
The version of @lovasoa does: http://lovasoa.github.io/sql.js/GUI/
Documentation?
Is the README the only documentation available for this project? I find myself having to read the source to understand the interface and features that are available (e.g., context managers, bulk_query
, etc.).
In the case of bulk_query
, the arguments are simply passed through to the underlying SQLAlchemy engine, with no explanation. I tracked it down in [SQLAlchemy's documentation](https:/
6.3版本REGEXP有问题
sql如下:select * from testreg where text.keyword <> REGEXP("?")
翻译的dsl如下:可以看到翻译的dsl是must,应该是must_not才对
{
"from": 0,
"size": 200,
"query": {
"bool": {
"filter": [
{
"bool": {
"must": [
{
"regexp": {
"text.keyword": {
"value": "?",
"flags_value": 65535,
"max_determinized_states": 10000,
"boost":
-
Updated
Apr 25, 2020 - Go
Hello Philip!
I think there is an issue with this part of the code of rqlite (store/store.go).
func (s *Store) Database(leader bool) ([]byte, error) {
if leader && s.raft.State() != raft.Leader {
return nil, ErrNotLeader
}
// Ensure only one snapshot can take place at once, and block all queries.
s.mu.Lock()
defer s.mu.Unlock()
f, err := ioutil.TempFile("", "rqlilte-snap-
Hi,
Similar to issue #125 it would be good to allow the same for the letsencrypt certbot container, could you please add a bind IP question during the bitwarden.sh install part in the letsencrypt section.
And something similar with (or storing the information for later in the previous
## Python/Regex fix
This is a reminder for me or a task if anyone wants :P
Basically, The last two questions aren't really regex's questions.
To do:
- Move said questions to correct place.
- Add new regex questions (Python related!)?
- Maybe add a new ## Regex section, as it is a valuable skill
-
Updated
May 19, 2020 - Java
nopCommerce version: 4.30 Beta
Steps to reproduce the problem:
Add any item to wishlist
Go to wishlist page
Click on Email a friend button
See here, personal message input is a textbox. it would be good it have textarea
After facing an issue caused by Ransack interpreting 1
/'t'
as true
and some unsuccessful research, I found about the sanitize args and the recommended way to skip them. The documentation never mentions that ransackable_scopes_sanitize_args
must be a class method and the example shown defines an instance method.
I think that's worth a documentation update, making more clear how to use th
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: