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,567 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
ENTERkey 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/
-
Updated
Apr 3, 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-
In the tutorial events there is this example:
const User = bookshelf.model('User', {
tableName: 'users',
initialize() {
this.on('saving', (model) => {
return User.forge({email: model.get('email')}).fetch().then((user) => {
if (user)
throw new Error('That email address already exists')
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
Jun 9, 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
I think the plugins docs need to extend beyond a single page now. I want to add a whole section on writing tests for plugins, showing how httpx can be used as seen in simonw/datasette-atom#3 and suchlike.
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: "trequeryVersion = '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)
-
Updated
Jun 11, 2020 - Swift
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
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语句如图,运行时会报错 ,我以为是运算符优先级问题,
再加了括号试试,同样会报错,是否不支持??运算符
 Used for many-to-many relationship only in order to specify the name of the intermediate table.
However it doesn't mention that it appears to follow the same form as the table attribute in entity classes, in the sense that you can pass it a tuple to specify the schema for databases like Postgresql.
Linters such as golangci-lint complain that you shouldn't pass nil to functions that take context.
do not pass a nil Context, even if a function permits it; pass context.TODO if you are unsure about which Context to use (staticcheck)
But in your code:
https://github.com/upper/db/blob/86a33f543c410d81cba466683cc4d03a609e0837/mysql/database.go#L83-L85
You only use the internal one on
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