Re: [sqlite] New word to replace "serverless"

I like "NO-SERVER" -Original Message- From: Richard Hipp To: General Discussion of SQLite Database Sent: Mon, Jan 27, 2020 2:18 pm Subject: [sqlite] New word to replace "serverless" For many years I have described SQLite as being "serverless", as a way to distinguish it from the more t

Re: [sqlite] Database speed comparison

I would be nice to have that page updated and contrast the old and new performance of SQLite. -Original Message- From: Cecil Westerhof To: SQLite mailing list Sent: Fri, Jan 10, 2020 10:37 am Subject: [sqlite] Database speed comparison I ran across this page:     https://sqlite.org/sp

Re: [sqlite] New Information Schema Views

Hi Keith: If there is a standard naming convention out there, we should consider adopting it. How about the naming listed in the link below:https://www.postgresql.org/docs/9.3/information-schema.html https://www.cmi.ac.in/~madhavan/courses/databases10/mysql-5.0-reference-manual/information-schema

Re: [sqlite] Using CSV.c

Maybe the following example may help: https://github.com/elau1004/TFR4SQLite/blob/master/src/test/031_testColumn.init Check out the wiki too regarding using the "-init" command line option. -Original Message- From: tbuckner To: sqlite-users Sent: Tue, Jan 10, 2017 2:03 am Subject:

Re: [sqlite] 64-bit SQLite3.exe

Hi Richard: I build my in the MinGW environment. These executable are native windows executable. Cygwin, have a thin emulation layer to make POSIX compatible. However, the GCC compiler both uses should be fine and should able to figure the environment. If your executable is compiled under

[sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin

Hi Dr. Hipp: Any plans to visit San Francisco? -Original Message- From: Richard Hipp To: General Discussion of SQLite Database Sent: Wed, Apr 20, 2016 10:21 am Subject: [sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin There will be an opportunity to meet some o

[sqlite] Parsing the contents of a field

Hi: Not sure what is the cost to first export the fields a flat file? Try https://github.com/elau1004/TFR4SQLite/wiki (may or may not fit your needs). It was intended to query flatfile with crazy delimiters, using SQLite query engine. If you can SELECT from a text file then you can insert th

[sqlite] whish list for 2016

A vote from me for OLAP analytical functions. -Original Message- From: Big Stone To: sqlite-users Sent: Sun, Dec 20, 2015 10:12 am Subject: [sqlite] whish list for 2016 Hi All, To prepare for 2016 greetings moment, here is my personnal whish list for sqlite: - analytic functions (wou

[sqlite] CSV excel import

Scott is right in the myriads of combination in handling csv/text file. Check out "Text File Reader for SQLite" at https://github.com/elau1004/TFR4SQLite/wiki Hope it meet some or all the needs dealing with importing text file. Since it is implemented as virtual table, one need to select the

[sqlite] CSV excel import

Along the lines virtual table, check out "Text File Reader for SQLite" at https://github.com/elau1004/TFR4SQLite/wiki Hope it meet some or all the needs dealing with importing text. file Since it is virtual table, one need to select the text and insert it into a table. -Original Message

[sqlite] Getting Cygwin error under MinGW

Hi Folks: I just downloaded the latest amalgamated source and got the following error. Do I need to change or set someting in the environment? $ cd sqlite/sqlite-amalgamation-3080900 $ gcc -DSQLITE_THREADSAFE=0 shell.c sqlite3.c -ldl sqlite3.c: In function `winGetTempname': sqlite3.c:37577: e

Re: [sqlite] SQLite3 internal performance

: Edward Lau@T60p ~/myCprograms $ gcc --version gcc.exe (GCC) 4.8.1 $ gcc -shared -O2 -o benchmark.dll benchmark.c Edward Lau@T60p ~/myCprograms $ sqlite3 SQLite version 3.8.7.4 2014-12-09 01:34:36 Enter ".help" for usage hints. Connected to a transient in-memory datab

[sqlite] SQLite3 internal performance

quot;benchmark"; SQLITE_EXTENSION_INIT2( pApi ); return sqlite3_create_module( db ,moduleName ,&myVModule ,NULL ); } // Default entry point which SQLite3 will look for when this module is loaded. int sqlite3_extension_init(sqlite3 *db ,char **ppzErrMsg ,const sq

[sqlite] SQLite3 internal performance

ule by comparison. As we transition to SSD the IO latency drops and bottlneck shift back to code. Comments and suggestions? Merry Christmas everyone. THE RAW LOGS: ===== Edward Lau@T60p ~/myCprograms $ gcc --version gcc.exe (GCC) 4.8.1 Copyright (C) 2013 Free Software Foundation, Inc. T

Re: [sqlite] SQLite3 internal performance

Re-posting due to message size too long. Hi Folks: I have read in many posting that SQLite is fast. How fast is fast? So over this holiday break I tried to take a reading on the VDBE performance to get a general idea. I wrote a quick module to enable me to exercise the engine simulating 32

Re: [sqlite] Whish List for 2015

Hi SQLite team: I cast my vote for some analytic functions too. -Original Message- From: big stone To: sqlite-users Sent: Sun, Dec 21, 2014 1:47 am Subject: [sqlite] Whish List for 2015 Hi all, To prepare for end of 2014 greetings moment, here is my whish list for 2015: - a minima

Re: [sqlite] SQLite as a meta database

as a meta database On 5 Nov 2014, at 9:28pm, Edward Lau wrote: > Maybe some time in the future a version 4 be started that incorporates many new advancement in the industry. Version 3 can still be continued for backwards compatibility and version 4 will break some but set the stage

Re: [sqlite] SQLite as a meta database

Hi SQLite Team: I second Nico's suggestion. We are finding new usage with SQLite especially with virtual tables. I understand the teams commitment to backwards compatibility. Maybe some time in the future a version 4 be started that incorporates many new advancement in the industry. Ve

Re: [sqlite] Window functions?

SQL Server 2008 does not have this behaviour. SELECT id, category_id, name, min(price) as minprice FROM( SELECT 1 id ,1 category_id ,'name1' name ,1 price -- Generate some data. ) AS cat_pictures GROUP BY category_id; produced: Msg 8120, Level 16, State 1, Line 3 Column

Re: [sqlite] Window functions?

Hi Eduardo: As Petite have mention, the following query selectid, category_id, name, min(price) as minprice from cat_pictures group by category_id; is missing the "id" and "name" columns in the GROUP BY clause ... per standard SQL standard requirement. If the above works, it is a

Re: [sqlite] Producing RFC4180-compliant CSV output

Hi Peter: Specifically, if you are going to use SQL Server Integration Services (SSIS) you can specify LF as the record delimiter. It defaults to {CR}{LF} but you can change it in the FlatFile Connection Manager under the Advance tab. -Original Message- From: Peter Waller To: sqli

Re: [sqlite] SELECTing WHERE calculation > 0

Hi Jose: In SQL, aggregate function cannot be used in the WHERE clause. Use the HAVING clause instead. Try this: SELECT cust, ProjID, proj, A_No, bdate, CASE Xtra4 WHEN 'y' THEN vEmail ELSE 'noemail' END, sum(ProjFund), sum(ProjFund)-sum(CASE X

Re: [sqlite] New DLLs and sources. Was: SQLite version 3.8.5 beta

Out of curiosity, I wrote a loadable module to benchmark sqlite3 in a 32 million iterations loop doing nothing to gauge its performance. There is no I/O from querying any tables. The rows are artificially created from incrementing an integer counter. 32 million rows is about the normal size o