Re: [sqlite] Inserting a new record (anywhere) into a table of ordered records that have an integer auto-increment primary key

[Delvin]

Afternoon all,

I am replying to this thread because I am a little confused here.  From what I 
have gotten from this thread, someone wants to be able to insert a record into 
a table based on an arbitrary record number (i.e. if a table already has 
records number 1, 2, 3, 4, etc., have the ability to insert a new record number 
3 and changing the record numbers (old record number) 3, 4, etc.

My confusing is this - are record numbers arbitrary to start with (since the 
table can be sorted in any manner) and the only reason for the record number 
column is to insure that the primary key is unique.

Thanks
Delvin


-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Jens Alfke
Sent: Saturday, 15 October, 2016 13:42
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] Inserting a new record (anywhere) into a table of ordered 
records that have an integer auto-increment primary key


> On Oct 15, 2016, at 11:12 AM, Keith Medcalf <kmedc...@dessus.com> wrote:
> 
>> Is there a way to do this automagically (like a specialized INSERT
>> command?) in Sqlite?
> 
> Unfortunately no, there is no way to do this on *ANY* database that uses the 
> relational database model.

There’s no need to dive into database theory! I’ll play devil’s advocate and 
say that this could pretty easily be done in SQLite by writing a simple 
extension function like in inbetween(a, b) that takes two strings and returns a 
string that sorts in between them, as I described previously.

Then you just make the table’s primary key a string and do
INSERT INTO mytable (ID, …) VALUES (inbetween($firstid, $secondid), …) 
where $firstid and $secondid are the the primary keys of the two rows you want 
to insert between.

In real life you’d probably just implement inbetween() as part of your program 
instead of as a SQLite function; I just wanted to prove that a relational 
database can in fact do this.

—Jens

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] "Responsive" website revamp at www.sqlite.org

[Delvin]

The site seems to be quite readable - I did notice that the text appears larger 
in landscape mode but it seems to appear quite readable in portrait mode (I 
viewed it with an iPhone 4S and an iPod Touch.

-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Darren Duncan
Sent: Monday, 5 September, 2016 16:28
To: SQLite mailing list 
Subject: Re: [sqlite] "Responsive" website revamp at www.sqlite.org

On 2016-09-05 1:55 PM, Richard Hipp wrote:
> Most of the world views the internet on their phone now, I am told, 
> and websites are suppose to be "responsive", meaning that they 
> reformat themselves to be attractive and useful for the majority who 
> view them through a 320x480 pixel soda-straw.  In an effort to conform 
> to this trend, I have made some changes to the *draft* SQLite website
> (http://sqlite.org/draft) Your feedback on these changes is 
> appreciated.  Please be sure to try out the new design both on a 
> narrow-screen phone and on a traditional desktop browser.  The goal is 
> to provide a more mobile-friendly website without reducing the 
> information content available to desktop users.

Superficially the altered site looks like an improvement.  It uses the simple 
and standard "viewport" declaration to achieve the low-hanging fruit.  Text is 
readable on my phone as with my computer at its default size while loading. 
Site still seems navigatable.  I didn't go very far though. -- Darren Duncan

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

[Delvin]

Mr. Jensen,

Thank you for the link - Although I am moving away from MS VS (I am using 
Dev-C++ more than MS VS) I have installed your MS VS Add-on so hopefully I will 
be able to use it soon.

Thank you again
Delvin


-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Erik Ejlskov Jensen
Sent: Thursday, 25 August, 2016 07:05
To: sqlite-users@mailinglists.sqlite.org
Subject: Re: [sqlite] SQLite in VS2015 Server Explorer (Bugs)

As an alternative to the System.data.sqlite design tools (depending on your 
requirements) you can use my free VS extension "SQLite Toolbox" 
https://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/
Mvh / Regards


Erik Ejlskov Jensen
http://twitter.com/erikej 
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] sqlite importing csv

[Delvin]

I was just going to suggest that - if it is the default directory - windows 
will start the command prompt in the C:\users\.  As 
long as the csv file is in this directory (but more than likely it is in the 
C:\users\\Documents directory.

Delvin


-Original Message-
From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] On 
Behalf Of Simon Slavin
Sent: Thursday, 25 August, 2016 01:02
To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org>
Subject: Re: [sqlite] sqlite importing csv


On 25 Aug 2016, at 6:59am, Alan <zl...@clear.net.nz> wrote:

> I right Clicked on start and selected the windows  cmd, and as I understand 
> it at the moment
> 
> by typing sqlite3 DXCC then it should be sitting in the directory or folder 
> that the DXCC  database is in

I don't think this is correct.  Once you have started cmd instead of starting 
'sqlite3', use this command 'cd'.  It reports your current directory.

Simon.
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users