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 9,981 public repositories matching this topic...
Issue Description
Is your feature request related to a problem? Please describe.
SQLITE_CANTOPEN error occurs when Sequelize is setup with a path to storage.db with folders that don't ex
See example below. Best plan is a lookup join, but we don't get that with the semi-join. The reason is that each side is projecting a tuple, and we are constraining those to be equal. A rule that detects this projection and converts to multiple equalities should fix this.
exec-ddl
CREATE TABLE ab (
a INT,
b INT,
PRIMARY KEY (a,b)
)
----
exec-ddl
CREATE TABLE cd (
c INT
The Audit backlog limit on Linux is currently hardcoded:
A command line option could be implemented to make this configurable
We consider to introduce the SqlSessionManager on reference documentation. It provide thread safe implementation of SqlSession.
Related issues
- #1529
The documentation here:
https://github.com/StackExchange/Dapper/tree/master/Dapper.Contrib#special-attributes
Says "[Table("Tablename")] - use another table name instead of the name of the class"
But that is not correct, the code here:
https://github.com/StackExchange/Dapper/blob/master/Dapper.Contrib/SqlMapperExtensions.cs#L309
takes the class name and add's an "s".
So it seems to
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
Environment
Knex version: 0.20.3
Database + version: psql (PostgreSQL) 12.1
OS: macOS 10.14.6
Bug
The expirationChecker property on the connection object is not being called to recreate the connection object with new credentials for the database, even though the timeout was reached.
The first time that a request is being made, it works fine but after the timeout, it won't all
TupleDomainFilters for IN predicates are optimized to use hash tables for lookups and offer O(1) performance, but NOT IN filters are not optimized and give O(n) performance. Yet, there is no reason why IN predicate optimization couldn't apply to NOT IN. We could extend BytesValues and BigintValues to add a flag indicating that this is a NOT filter and add logic to com.facebook.presto.orc.TupleDoma
We have a simple MergeTree table with ~1M records. Sometimes we need to get last 10 records ordered by id, but we’d also like to get the total number of rows returned by the query if there were no limit.
SELECT count()
FROM blocks
┌─count()─┐
│ 600000 │
└─────────┘
Запрос
SELECT id
FROM blocks
ORDER BY id DESC
LIMIT 10
FORMAT JSON
ClickHouse v.19.17.5.18
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
Relevant system information:
- OS: archlinux 64bit kernel 5.1.15
- PostgreSQL version (output of
postgres --version): postgres (PostgreSQL) 11.2 - TimescaleDB version (output of
\dxinpsql): 1.5.1 - Installation method: compile from source
Describe the bug
before upgrade, I'm using timescaledb 1.3, pg_dump gives no warning
pg_dump -U myname --format=custom An powerful enhanced toolkit of MyBatis for simplify development
-
Updated
Jan 9, 2020 - Java
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:/
It looks like a great tool, is it possible to translate the documentation to English?
Documentation
http://essql.nlpcn.org/ seems to be not working. Could you help me the page where can I get the full syntax for all supported queries like how to use
- has_children
2.has_parent, - like query (select * from index where field like 'test*'), here I need to use "test" as lower case and '*' which is not the same as sql.
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
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-
Which version and edition of Flyway are you using?
5.0.7
Which client are you using? (Command-line, Java API, Maven plugin, Gradle plugin)
Java with Hibernate
The linked Stackoverflow entry is only for Hibernate 4.x
I found this way to include Flyway with Hibernate 5.x for example in Wildfly >= 10
Perhaps it is worth for documentation:
import java.util.Map;
iMy bitwarden-mssql docker container shows this
2019-10-17 23:59:01.42 spid52 BackupDiskFile::CreateMedia: Backup device '/etc/bitwarden/mssql/backups/vault_FULL_20191017_235901.BAK' failed to create. Operating system error 2(The system cannot find the file specified.).
I checked that within the docker container I could create this file using 'touch',
and I can see this file appear on the
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
nopCommerce version: 4.2
Steps to reproduce the problem:
I wanted to show how much money remaining for free shipment. I couldn't find a widget inside the OrderSummary/default.cshtml before the
@await Component.InvokeAsync("OrderTotals", new { isEditable = Model.IsEditable }) line
It is good to have a widget there so we can add any warning message there
OrientDB Version: 3.0.x
Java Version: N/A
OS: Web
Documentation Only
Expected behavior
should bring me to the OrientJS API documentation
Actual behavior
get a page 404 error
Steps to reproduce
go to : http://orientdb.com/docs/3.0.x/orientjs/OrientJS.html
find the link for API Docs
click it.
Since we are working on #732 and adding a Concurrent.Futures backend we should add documentation on how to use it.
:school_satchel: :rocket: :tada: A list of interview questions. This repository is everything you need to prepare for your technical interview.
-
Updated
Jan 9, 2020
Always to test tidb performance by POC,sometimes we will use the production data,sometimes we can use public dataset such as ONTIME,like percona. the Genaral data format is CSV,could you provide an example like Percona-lab which used for TiDB.
https://github.com/Percona-Lab/ontime-airline-performance/tree/master/mysql