The Wayback Machine - https://web.archive.org/web/20200707091728/https://github.com/topics/sqlite
Skip to content
#

SQLite

sqlite logo

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,711 public repositories matching this topic...

ozkanonur
ozkanonur commented Apr 13, 2020

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)

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

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-
frames75
frames75 commented Feb 19, 2020

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')
    
sgrif
sgrif commented Feb 18, 2020

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

dhui
dhui commented Apr 11, 2020

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

anketwokings
anketwokings commented Feb 6, 2018

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
datasette
labstersteve
labstersteve commented Jan 18, 2020

While it's sometimes valuable to know how a project has developed, there is usually little justification for including this information in the README, and certainly not immediately after other key information such as "what does this package do, and who might want to use it?"

Might I recommend that the feature history is migrated to an Appendix in the documentation?

maritaria
maritaria commented Sep 26, 2017
	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
bovquier
bovquier commented Aug 8, 2019

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)
KaneLeung
KaneLeung commented Oct 25, 2019

TIM截图20191025180951

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语句如图,运行时会报错 ,我以为是运算符优先级问题,
再加了括号试试,同样会报错,是否不支持??运算符
![TIM截图

jtoberling
jtoberling commented Aug 28, 2019

As of first congrats for this package - I'm using it quite often & it's a great help.

I'd like to ask a feature request - add support for MSSQL DB.
The main official mode of connection recommended by MS is ODBC/PDO.
[https://docs.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-2017#microsoft-odbc-driver-17-for-sql-server](ht

Ulfasaar
Ulfasaar commented Feb 20, 2020

Currently for table it says that the table has to be a string.

table

    (str) 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.

Created by D. Richard Hipp

Released August 17, 2000

Website
www.sqlite.org
Wikipedia
Wikipedia

Related Topics

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