John,
There is a lot of documentation on the SQLite website.
Here's the 'official' docs on creating a table
https://www.sqlite.org/lang_createtable.html
A Sqlite database consists of many tables. I am unsure if there is an
upper limit, if there is, its more tables than I have ever created.
On Mon, Nov 21, 2016 at 1:12 PM, Ronald Gombach wrote:
>
> Is there a pre-c binary of SQLIte available for down load that includes a
> math library. I particularly need the “median” function.
>
> If not, can someone point me to instructions on compilation command line to
>
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I understand that with
Sqlite a database includes tables and other items. The scenario that I
do not understand, is: say I have a log file with about 7 fields
totaling about 80
Hi, John,
On Mon, Nov 21, 2016 at 12:29 PM, John R. Sowden
wrote:
> First of all, I come from the dBASE/Foxpro world. There is no distinction
> between a table and a database. I understand that with Sqlite a database
> includes tables and other items. The scenario
On 19/11/16 08:08, Kevin O'Gorman wrote:
> System with problems: Running Xubuntu Linux 16.04.1, Python 3.5.2.
[...]
> System without this problem: Running Ubuntu Linux 14.04.5, Python 3.4.3.
You are good on Python versions then. My remaining recommendation is to
make the process that does SQLite
On Mon, Nov 21, 2016 at 9:41 AM, Roger Binns wrote:
> On 19/11/16 08:08, Kevin O'Gorman wrote:
> > System with problems: Running Xubuntu Linux 16.04.1, Python 3.5.2.
> [...]
> > System without this problem: Running Ubuntu Linux 14.04.5, Python 3.4.3.
>
> You are good on
Thank you all for your answers and direction for further information.
Hopefully, I will not bring these subjects up again. :)
John
On 11/21/2016 09:29 AM, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I
On 21 Nov 2016, at 17:29, John R. Sowden wrote:
First of all, I come from the dBASE/Foxpro world. There is no
distinction between a table and a database. I understand that with
Sqlite a database includes tables and other items. The scenario that
I do not understand, is: say I have a log
> On Nov 21, 2016, at 10:08 AM, John R. Sowden
> wrote:
>
> Thank you all for your answers and direction for further information.
> Hopefully, I will not bring these subjects up again. :)
Some of what you’re asking applies to any SQL database. The SQLite docs do
Basic syntax question on qualified table names in a select. I've got 2 attached
databases, say db1 and db2, and I try to run...
insert into main.foo
select db1.foo.*
from db1.foo left outer join db2.bar
on db1.foo.pk = db2.bar.pk
where db2.bar.pk is null;
and I get "Error: near "*": syntax
Hi everyone,
I have a DB migration question. I have a table called "employees" and it has a
UNIQUE constraint on "employee_email". With some new features being requested,
I need to relax the constraint and have a new constraint on "employee_email" +
"employee_number". Since SQLite ALTER table
On 11/21/16, Vikas Aditya wrote:
>
> Currently we are using:
>
> sql = "INSERT INTO {} SELECT * FROM {}".format(totable, fromtable)
> cur.execute(sql)
>
> So, a single line statement can copy from old to new. But will this work
> fine even if I have 100s of thousands of
Hi Ryan,
Thanks for the transaction suggestion. We will do that.
I provided a simplistic example for constraints, but I think I have an answer
now.
Thanks,
Vikas
On Nov 21, 2016, at 12:24 PM, R Smith wrote:
>
>
> On 2016/11/21 9:57 PM, Vikas Aditya wrote:
>> Hi
On 2016/11/21 9:57 PM, Vikas Aditya wrote:
Hi everyone,
I have a DB migration question. I have a table called "employees" and it has a UNIQUE constraint on
"employee_email". With some new features being requested, I need to relax the constraint and have a new
constraint on "employee_email"
> And since the "*" forms are considered bad style
I have done this, not knowing it is bad style. Can you provide some reasons
why it is bad? I can assume, "Applications are supposed to be controlled
environments, and using tbl.* introduces uncertainty outside the
applications control." But are
On 11/21/16, Don V Nielsen wrote:
>> And since the "*" forms are considered bad style
>
> I have done this, not knowing it is bad style. Can you provide some reasons
> why it is bad?
Years later when somebody does "ALTER TABLE ... ADD COLUMN" your
application will begin
Thank You!
Vikas
On Nov 21, 2016, at 12:09 PM, Richard Hipp wrote:
> On 11/21/16, Vikas Aditya wrote:
>>
>> Currently we are using:
>>
>> sql = "INSERT INTO {} SELECT * FROM {}".format(totable, fromtable)
>> cur.execute(sql)
>>
>> So, a single
On 11/21/16, Jens Alfke wrote:
> Does SQLite ever open or create files while a database connection is already
> open?
(1) When you run ATTACH.
(2) The open/create of the original database is deferred until you
actually need to read or write the database, so the open/create
On 11/21/16, David Raymond wrote:
>
> Following the nice SQL diagrams it looks like in a select you can only have
> * or table-name.*, whereas in other places you can have
> schema-name.table-name. Granted, the second version can be made prettier and
> more readable, but
Does SQLite ever open or create files while a database connection is already
open? Or does that only happen while creating the connection?
(I'm using WAL mode, if it makes a difference.)
--Jens [via iPhone]
___
sqlite-users mailing list
On 21 Nov 2016, at 21:55, Igor Korot wrote:
> You are of course correct. It does depend on an application.
> However, I tried to explain the SQLite and its paradigm in terms of
> the dBase/FoxPro.
You were correct also, Igor, and gave good advice.
Best regards,
Niall
Hi, Niall,
On Mon, Nov 21, 2016 at 12:52 PM, Niall O'Reilly wrote:
> On 21 Nov 2016, at 17:29, John R. Sowden wrote:
>
>> First of all, I come from the dBASE/Foxpro world. There is no distinction
>> between a table and a database. I understand that with Sqlite a database
Hi!
SQL Maestro Group announces the release of SQLite Maestro 16.11, a complete
Windows GUI solution for SQLite database management. The new version is
immediately available at
http://www.sqlmaestro.com/products/sqlite/maestro/
Top 10 new features
=
1. Support for the FTS5
Can't you count how many rows there are and then sort by the variable of
interest, limiting output to half the count, all within SQL?
Roman
Sent from my T-Mobile 4G LTE Device
Original message
From: Ronald Gombach
Date: 11/21/16 7:12 AM (GMT-05:00)
To:
Is there a pre-c binary of SQLIte available for down load that includes a math
library. I particularly need the “median” function.
If not, can someone point me to instructions on compilation command line to
include the math library (OS-X).
Thanks for any info you can share.
Ron Gombach
Thank you, it's working now.
Regards
Jonathan
On 21/11/2016 09:19, Bart Smissaert wrote:
I think you will need this ODBC driver:
http://www.ch-werner.de/sqliteodbc/
RBS
On Mon, Nov 21, 2016 at 8:12 AM, J Trahair
wrote:
Hi everyone
I am trying to link a
Hi everyone
I am trying to link a VB6 project to SQLite. (I can do this fine in
VB.Net.) I am using System.Data.SQLite.dll file version 1.0.66.0, and
the following connection properties:
Option Explicit
Public grsUtilities As ADODB.Recordset
Public gconn As ADODB.Connection
Public mstrSQL As
I think you will need this ODBC driver:
http://www.ch-werner.de/sqliteodbc/
RBS
On Mon, Nov 21, 2016 at 8:12 AM, J Trahair
wrote:
> Hi everyone
>
> I am trying to link a VB6 project to SQLite. (I can do this fine in
> VB.Net.) I am using System.Data.SQLite.dll
28 matches
Mail list logo