Skip to content
#

SQL

sql logo

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...

wwar
wwar commented Apr 26, 2020

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
cockroach
JLsushmaumesh
JLsushmaumesh commented Mar 31, 2020

Document : https://osquery.io/schema/4.2.0
Table : md_devices [Software RAID array settings]

Column's :

  1. active_disks | INTEGER | Number of active disks in array
  2. failed_disks | INTEGER | Number of active disks in array
  3. 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
dbeaver
KOLANICH
KOLANICH commented Jan 11, 2019

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

tristaZero
tristaZero commented Apr 23, 2020

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

presto
tdcmeehan
tdcmeehan commented Apr 21, 2020

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.

directus
benhaynes
benhaynes commented Nov 28, 2018

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

willvousden
willvousden commented Oct 13, 2018

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:/

ZQbd
ZQbd commented Sep 10, 2019

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":

JeanGolang
JeanGolang commented Feb 7, 2017

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-
server
surister
surister commented Jan 21, 2020

This is a reminder for me or a task if anyone wants :P

imagen

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
jeduardo824
jeduardo824 commented Jul 18, 2019

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

Created by Donald D. Chamberlin, Raymond F. Boyce

Released 1986

Wikipedia
Wikipedia

Related Topics

database
You can’t perform that action at this time.