SQLite

SQLite is a C-language library that implements a small, fast, self-contained, high-reliability, full-featured, SQL database engine. SQLite is the most used database engine in the world. SQLite is built into all mobile phones and most computers and comes bundled inside countless other applications that people use every day.
Here are 4,454 public repositories matching this topic...
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)
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
Details for the issue
What did you do?
- Enter simple query, e.g.
select 1;
- Press
ENTER
key many times that query from step
Code Documentation
There is very little documentation available for the source code. As such, the source is highly difficult to understand and interpret by others. Please consider adding in appropriate documentation as soon as possible.
-
Updated
Apr 20, 2020 - Java
Documentation should be updated for database creation on MacOS (using Swift 4.2)
Link to affected documentation section: https://github.com/stephencelis/SQLite.swift/blob/master/Documentation/Index.md#read-write-databases
try FileManager.default.createDirectoryAtPath(
path, withIntermediateDirectories: true, attributes: nil
should become:
try FileManager.default.createDirectory(
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/
for example,i want the Name
field search with name like 、> 、<、 is null、 ...
,not only name = ?
type Dapp struct {
UUID string `xorm:"varchar(36) 'uuid'"`
Name string
Subtitle string
Category string
Permission string
Synopsis string
Score float64
Logo string
Banner string
Snapshot string
Video
Introduction
It seems the API-description for "fetch" does not match the actual behaviour and the changelog information.
Issue Description
In the API description for "fetch"
https://bookshelfjs.org/api.html#Collection-instance-fetch
it reads
If you wish to trigger an error if the fetched collection is empty, pass {require: true} as one of the options to the fetch call
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-
Given that we support CURRENT_TIMESTAMP
, the lack of CURRENT_DATE
feels like an omission. While you can hack it with date(now)
, I keep finding myself wishing there was a direct way to reference this. Given that now
means CURRENT_TIMESTAMP
, I think there's precedent for today
meaning CURRENT_DATE
. This is supported by all backends we support (and is in the ISO standard I believe).
Is your feature request related to a problem? Please describe.
Provide help in CLI for sub-commands
Describe the solution you'd like
Sub-commands help should describe the sub-command's functionality and options available for the sub-command
Describe alternatives you've considered
N/A
Additional context
See: golang-migrate/migrate#370
-
Updated
May 21, 2020 - PHP
Via this image: https://github.com/neilotoole/xcgo
It is possible to produce a bunch of multi-platform release artifacts.
neilotoole/xcgo
's companion example project sqlitr, via goreleaser
, publishes a trivial sqlitr query tool in these forms:
- brew
- scoop
- snap
- deb
- rpm
- docker
- tarball
Note snap
. Not trivial to do... `sna
How to recreate
-
Preview a page that has content stored in contentblocks.
-
When previewing a page that has content stored in
contentblocks
, the contentblocks do not show.
Expected behaviour
The contentblocks showing exactly as they do on the saved webpage
Error
With strict_variables: true
, the error that is given is
Key "block" for array with keys "textsection" do
Since that object is passed to the extra_template_vars
hooks AND the classes registered by register_facet_classes
it should be part of the documented interface on https://datasette.readthedocs.io/en/stable/internals.html
I could also start passing it to the register_output_renderer
callback.
let User = db.define("user", {
name: { type: "text", required: true, unique: true },
task_name: String,
task_data: Object,
last_seen: { type: 'date', time: true },
card_url: { type: 'text' },
});
let Group = db.define("group", {
name: { type: "text", required: true },
general_chat: { type: "text", required: true, unique: true },
admin_chat: { type: "t
requeryVersion = '1.6.0'
requeryVersion = '1.6.1'
E/BaseViewModel: java.sql.SQLNonTransientConnectionException
io.requery.PersistenceException: java.sql.SQLNonTransientConnectionException
at io.requery.sql.EntityDataStore.checkConnectionMetadata(EntityDataStore.java:588)
at io.requery.sql.EntityDataStore$DataContext.getTransactionMode(EntityDataStore.java:747)
Originally posted by @dimitri in https://github.com/dimitri/pgloader/timeline
That's good thinking, and I think that's relevant for another PR. The PR introducing the statistics singleton should also take care of the following bits of refactoring of the code:
- the singleton is named “state” as I initially though I would update the global state of the migration to be able to know
-
Updated
May 24, 2020 - Swift
DB.Updateable<t_stock_document>().SetColumns(k => new t_stock_document() { OutQTY = k.OutQTY - delDoc.F_Qty ?? 0, OutFinish = false }).Where(k => k.F_ID == delDoc.RelateID).ToSql();
语句中,使用??生成的Sql语句如图,运行时会报错 ,我以为是运算符优先级问题,
再加了括号试试,同样会报错,是否不支持??运算符

But in your code:
https://github.com/upper/db/blob/86a33f543c410d81cba466683cc4d03a609e0837/mysql/database.go#L83-L85
You only use the internal one on
First of all, thanks to the contributors of Sqitch for all of your work! It's a great, simple tool.
I am struggling to run my first deployment of a newly initialized Sqitch project. I have successfully written and tested my deploy
, revert
, and verify
code on a local test DB. However, when I run the deployment on our prod machine, I consistently get an error,
access denied for use
Created by D. Richard Hipp
Released August 17, 2000
- Website
- www.sqlite.org
- Wikipedia
- Wikipedia
Issue Description
What was unclear/insufficient/not covered in the documentation
How to update and increment in one single query
If possible: Provide some suggestion on how we can enhance the docs
Add this to the docs.
Additional context
#7268
Issue Template Checklist