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

2020-01-28 Thread Amit Chaudhuri
I like the slightly opaque "compact".
A

On Tue, 28 Jan 2020 at 13:31, Donald Shepherd  wrote:
>
> On Wed, 29 Jan 2020 at 12:26 am, Jose Isaias Cabrera 
> wrote:
>
> >
> > R Smith, on Tuesday, January 28, 2020 06:39 AM, wrote...
> > >
> > > I do not have a great suggestion to add, but to observe that the best
> > > suggestions I think are: NOT changing, (or if we have to) "Server-Free"
> > > or "Localized".
> >
> > I agree with these, but localize is another buzz word for translation.
>
>
> Internationalisation/translation is my first thought when I hear
> localisation/localised, a buzzword that must be at least 15 years old given
> when I first encountered it used like that.
>
> Regards,
> Donald Shepherd.
>
> >
> ___
> 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] Things you shouldn't assume when you store names

2019-11-12 Thread Amit Chaudhuri
Ha ha ha - Oh Simon.what *have* you done? [Apologies for the noise
- could not resist this one.]

On Sat, 9 Nov 2019 at 19:26, Simon Slavin  wrote:
>
> Since I don't see many posts yet this weekend, please excuse one of mine 
> which isn't exactly on charter.  Feel free to argue me out of posting in 
> personal (offlist) email.
>
> In a previous job I got to see databases made up by all sorts of other people 
> and organisations.  Every time I saw a field called 'firstname' or 'second 
> name' or 'surname' or 'familyname' I groaned.  So I was nodding along as I 
> read this:
>
> 
>
> I think this one is unusually well-written.
>
> In case you want to know how best to handle personal names, the current 
> consensus seems to be to use a single field containing the whole name, which 
> can be searched by substring.  Computer systems for places with non-Roman 
> character sets sometimes use two fields: name in local characters (Chinese, 
> Devanagari, etc.) and name in Roman characters.
>
> Also note that current privacy legislation in the US and EU means you are not 
> allowed to ask for anything like 'full legal name' unless you cannot run your 
> business without it.  Ask them for their name, and store what they tell you, 
> with the words in the order they gave them.  If you need to sort people in 
> name order (think very hard about why, first), create a field called 'sort 
> order' and populate it yourself.  Sorting is your problem, not that of the 
> people you're sorting.
>
> Part of a continuing series including falsehoods about dates, times, places, 
> street addresses, gender, relations, phone numbers, taxes, and amounts of 
> money.
>
> Good luck, and watch your back.
> ___
> 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


[sqlite] Compiling sqlite as as library

2015-07-02 Thread Amit Chaudhuri
Maybe this will help?

http://stackoverflow.com/questions/4234767/how-do-i-build-sqlite3-from-command-line

On Thu, Jul 2, 2015 at 10:25 AM, Prakash Premkumar
 wrote:
> I tried with the following flags :
>
> gcc -arch x86_64 -o sqlite3.o sqlite3.c shell.c
>
>
>   and
>
>
>> gcc -m32  -o sqlite3.o sqlite3.c shell.c
>
>
> but both results in the same error.
>
> Can you please help me solve this ?
>
> On Thu, Jul 2, 2015 at 2:47 PM, Andy Ling  wrote:
>
>> > I get the following error while trying to compile after linking with the
>> > library
>> >
>> > ld: warning: ignoring file
>> > > /Users/prakash-2282/Downloads/sqlite-amalgamation-
>> > 201506301510/libsqlite3.a,
>> > > file was built for archive which is not the architecture being linked
>> > > (x86_64):
>> > > /Users/prakash-2282/Downloads/sqlite-amalgamation-
>> > 201506301510/libsqlite3.a
>> >
>>
>> I'm guessing, but it looks like your compiling for 64bit and linking to a
>> 32bit system
>> or vice versa.
>>
>> Regards
>>
>> Andy Ling
>>
>> ---
>> This email has been scanned for email related threats and delivered safely
>> by Mimecast.
>> For more information please visit http://www.mimecast.com
>>
>> ---
>>
>> ___
>> sqlite-users mailing list
>> sqlite-users at mailinglists.sqlite.org
>> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
>>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] problem compiling std_call dll

2015-03-01 Thread Amit Chaudhuri
Bart,

you say "don't know anything about C or C++ or compiling C code"
Perhaps this will help.

The error message (unresolved) external means that the linker is
trying to find something (_sqlite3_db_filename in this case) but it
cannot.

Possible common causes include - it has been misspelt (I'm looking at
that underscore) or you have failed to point it at a library.

I'm afraid I'm not fluent in the windows tools to track this down and
don't have a system I can follow along with.  But on Linux one might
use the nm utility to examine a contents of library files for symbols.

Regards,

Amit

On Sat, Feb 28, 2015 at 11:22 AM, Bart Smissaert
 wrote:
> Trying to compile a std_call dll to be used with VB6 and VBA.
> Using instructions and files from this website:
> https://sqliteforexcel.codeplex.com/
> All works well and have added a few SQLite functions that weren't in the
> compiled dll
> as in the download section from that website.
> However having problems adding sqlite3_db_filename.
>
> I added this to sqlite3.h:
>
> const char *sqlite3_db_filename(sqlite3 *db, const char *zDbName);
>
> and this to SQLite3_StdCall.c:
>
> SQLITE3_STDCALL_API const char * __stdcall
> sqlite3_stdcall_db_filename(sqlite3 *pDb, const char *zDbName)
> {
>  return sqlite3_db_filename(pDb, zDbName);
> }
>
> It doesn't compile and gives linking errors:
>
> Error 1 error LNK2001: unresolved external symbol
> _sqlite3_db_filename
> C:\Users\Bart\SQLiteForExcel\Source\SQLite3_StdCall\SQLite3_StdCall.obj
> SQLite3_StdCall
> Error 2 error LNK1120: 1 unresolved
> externals 
> C:\Users\Bart\SQLiteForExcel\Source\SQLite3_StdCall\Release\SQLite3_StdCall.dll
> 1 1 SQLite3_StdCall
>
> Strangely it doesn't point to a line in the block SQLITE3_STDCALL_API but
> points to line 1.
> This is at the start of SQLite3_StdCall.c:
>
> #include "stdafx.h"
> #include "SQLite3_StdCall.h"
>
> Compiling this on Windows 7 with Microsoft Visual Studio Professional
> Studio 2013.
> Admittedly, don't know anything about C or C++ or compiling C code, so I am
> sure I must
> be overlooking something simple and silly, but just can't figure it out.
> Any ideas what could be the problem here?
>
>
> RBS
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] another typo in planner.html

2013-05-14 Thread Amit Chaudhuri
Seection 2.0 line 4

SQLite processes this by gather all the output of query and then running ...

SQLite processes this by gathering all the output of query and then running
...

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


[sqlite] Trivial typo in queryplanner.html docs

2013-05-14 Thread Amit Chaudhuri
Hi all,

reading through queryplanner.html today I notice a trivial typo in section
1.6, line 5:

If there were a third column, it would be used to break ties for the first
to columns.
If there were a third column, it would be used to break ties for the first
tWo columns.

^^^

It doesn't spoil the read :)

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


Re: [sqlite] Programming API vs console

2013-04-27 Thread Amit Chaudhuri
CREATE TABLE playersdrafted(playerid integer, id ineteger,

Don't think ineteger is what you really mean.:)
Seen it twice now so guessing it's actually in the code


On Sat, Apr 27, 2013 at 8:34 AM, Igor Korot  wrote:

> Simon,
> In the other area of the program I have a transaction that does 5 or 6
> inserts and no selects.
> This transaction works fine as I just verified.
>
> Now in the failing case the flow goes like this:
>
> First the program updates couple of tables, then it inserts this particular
> record.
> This algorithm is going thru the loop of the players vector.
> I'm using the same handle and the same statement object. Only different
> queries.
>
> After every query I'm calling sqlite3_finalize() to free the memory and the
> statement object.
>
> Am I doing it wrong?
>
> Thank you.
>
>
> On Sat, Apr 27, 2013 at 12:10 AM, Simon Slavin 
> wrote:
>
> >
> > On 27 Apr 2013, at 8:05am, Igor Korot  wrote:
> >
> > > No. Using straight insert with values does not work.
> > > Record still not inserted.
> >
> > Okay, so you now don't have to worry about parameters, or a sub-select or
> > any of those things.  What you have identified is that a simple INSERT
> with
> > all values supplied returns SQLITE_OK but doesn't insert a record.
> >
> > Make up a simpler TABLE and try inserting into that one.  A table with
> one
> > INTEGER column ?  In fact, see if you can get any INSERT command working
> at
> > all, then work your way up to one that doesn't work and see if you can
> find
> > the thing that makes the INSERT stops working.
> >
> > Simon.
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Is it possible to check a data type in a query?

2011-07-15 Thread Amit Chaudhuri
Perfect - thank you both..

On Thu, Jul 14, 2011 at 12:15 PM, Simon Slavin <slav...@bigfraud.org> wrote:

>
> On 13 Jul 2011, at 1:13pm, Amit Chaudhuri wrote:
>
> > I have situation where a column may contain prices (REAL) or a string
> > meaning "no price for this, sorry." I can handle this in application code
> > but was wondering if I am overlooking a Sqlite feature which might do the
> > same out of the box: perhaps a TYPE( ) or an IsText( ) function..?
>
> There is a 'typeof'.  But you didn't know the proper way to do it.  What
> you do is set up the column to be a number format (real or integer, however
> you hold your prices) and use NULL when you don't have a price.  Then you
> can very quickly and easily check for a NULL with
>
> typeof(X) = 'null'
> nullif(X,Y)
>
> or convert it to your 'no price for this' string with
>
> ifnull(X,'No price for this, Sorry.')
>
> In fact this is what NULL means in SQL: something like 'data missing' or
> 'value unknown'.  So it is exactly what you really want.  For more details
> see
>
> <http://www.sqlite.org/lang_corefunc.html>
>
> For how to do calculations on numbers that might be NULL, see
>
> <http://www.sqlite.org/lang_aggfunc.html>
>
> For more details than you need don't bother seeing
>
> <http://www.sqlite.org/nulls.html>
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Is it possible to check a data type in a query?

2011-07-14 Thread Amit Chaudhuri
Hi all,

I have situation where a column may contain prices (REAL) or a string
meaning "no price for this, sorry." I can handle this in application code
but was wondering if I am overlooking a Sqlite feature which might do the
same out of the box: perhaps a TYPE( ) or an IsText( ) function..?

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


Re: [sqlite] ATTACH DATABASE .tables .schema ?

2011-06-14 Thread Amit Chaudhuri
I'm a huge fan of the command line tool. At work we use it extensively when
prototyping.  We're probably amongst the less technically sophisticated of
users, so the ability to quickly script an approach using a few text files
is something we value hugely. It's a great way of weaning people off
spreadsheets in situations where data volumes stretch their capabilities.
But I sometimes wonder if it could be an even bigger plus with a little more
attention.  This seems to me like a worthy area for enhancement if it is
technically "easy."

If we had strong C skills I'd be inclined to have a go. [But I can say that
in full safety!]


On Mon, Jun 13, 2011 at 4:09 PM, Jay A. Kreibich  wrote:

> On Sun, Jun 12, 2011 at 05:29:32PM -0400, ap scratched on the wall:
> > When I attach additional DB's with ATTACH DATABASE how can I view the
> schema
> > or tables in the (non main) databases?
> >
> >
> >
> > ATTACH DATABASE 'C:\temp\test.db' AS T
> >
> > .schema  T
> >
> > .tables T
> >
> > Produce no results.
>
>   You can't.  The CLI dot-commands only show results for the
>  "main" and "temp" databases.
>
>   -j
>
>
> --
> Jay A. Kreibich < J A Y  @  K R E I B I.C H >
>
> "Intelligence is like underwear: it is important that you have it,
>  but showing it to the wrong people has the tendency to make them
>  feel uncomfortable." -- Angela Johnson
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] In-memory database with persistent storage

2011-03-23 Thread Amit Chaudhuri
..representation of a decent sized real world network..

On Tue, Mar 22, 2011 at 10:59 AM, Bart Smissaert
<bart.smissa...@gmail.com>wrote:

> > through a version of dijkstra's routing algorithm
>
> Just out of interest, what data is this working on?
>
> RBS
>
> On Tue, Mar 22, 2011 at 7:25 AM, Amit Chaudhuri
> <amit.k.chaudh...@gmail.com> wrote:
> > [Not at all expert in sqlite but here's a practical example of speed up
> > using ":memory:" and perhaps a slightly different strategy for getting at
> > the persistent data.]
> >
> > I use sqlite3 with Qt4 / C++ for an application which reads in an
> undirected
> > graph and then chunks through a version of dijkstra's routing algorithm.
>  A
> > colleague runs this on his machine and it takes all night on a large
> network
> > running on a database on disk.  On my own machine which is more powerful
> it
> > probably runs a lot faster but still takes a couple of hours plus.
>  Changing
> > to an in memory database, reading data in and processing in memory brings
> > the run time down to a couple of minutes.  So yes - running in memory can
> be
> > much quicker.  At the end of the run I attach an on disk database and
> copy
> > out the tables I need to save using "create table select" .
> >
> > A
> >
> > On Mon, Mar 21, 2011 at 1:13 PM, Simon Friis <simo...@gmail.com> wrote:
> >
> >> I know how to create a database that exists only in memory by using
> >> the :memory: filename. This however, creates a new database every time
> >> and it can not be saved.
> >>
> >> Is is possible to make SQLite load a database file into memory and
> >> then save it back to the file again when the connection to the
> >> database is closed?
> >>
> >> Would it improve speed?
> >>
> >> - paldepind
> >> ___
> >> sqlite-users mailing list
> >> sqlite-users@sqlite.org
> >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >>
> > ___
> > sqlite-users mailing list
> > sqlite-users@sqlite.org
> > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> >
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] In-memory database with persistent storage

2011-03-22 Thread Amit Chaudhuri
[Not at all expert in sqlite but here's a practical example of speed up
using ":memory:" and perhaps a slightly different strategy for getting at
the persistent data.]

I use sqlite3 with Qt4 / C++ for an application which reads in an undirected
graph and then chunks through a version of dijkstra's routing algorithm.  A
colleague runs this on his machine and it takes all night on a large network
running on a database on disk.  On my own machine which is more powerful it
probably runs a lot faster but still takes a couple of hours plus.  Changing
to an in memory database, reading data in and processing in memory brings
the run time down to a couple of minutes.  So yes - running in memory can be
much quicker.  At the end of the run I attach an on disk database and copy
out the tables I need to save using "create table select" .

A

On Mon, Mar 21, 2011 at 1:13 PM, Simon Friis  wrote:

> I know how to create a database that exists only in memory by using
> the :memory: filename. This however, creates a new database every time
> and it can not be saved.
>
> Is is possible to make SQLite load a database file into memory and
> then save it back to the file again when the connection to the
> database is closed?
>
> Would it improve speed?
>
> - paldepind
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


Re: [sqlite] Selective update of a column

2010-11-18 Thread Amit Chaudhuri
Simon - thanks v. much.  Makes complete sense now - and it does precisely
what I wanted. :)
{Appreciate the tip on the index - performance hasn't been an issue yet but
I'm sure I'll end up using it.}

On Wed, Nov 17, 2010 at 12:51 PM, Simon Slavin <slav...@bigfraud.org> wrote:

>
> On 16 Nov 2010, at 3:29pm, Amit Chaudhuri wrote:
>
> > The approach I tried was to perform 2 sequential updates using first the
> > fixed call source table then the mobile. I tried to restrict the update
> to
> > rows in target where the class of call (fixed or mobile) corresponded to
> the
> > content of the source.
> >
> > What seems to happen is that the second update blats the updates
> performed
> > by the first: I can have either fixed results or mobile results but not
> > both.
>
> You /nearly/ got it right.  Your commands were
>
>update target set cost = (select cost from source1 where
> source1.Aend=target.Aend and source1.type=target.type and FM='Fixed');
>
>update target set cost = (select cost from source2 where
> source2.Aend=target.Aend and source2.type=target.type and FM='Mobile');
>
> Your problem is that you have the clause about FM in the wrong part.  The
> FM column is in the table you're updating, not in the source.  So the clause
> about FM should be part of the UPDATE command, not part of the SELECT.  Your
> code should look more like
>
>UPDATE target SET cost = (SELECT cost FROM source1 WHERE
> source1.Aend=target.Aend AND source1.type=target.type) WHERE FM='Fixed';
>
>UPDATE target SET cost = (SELECT cost FROM source2 WHERE
> source2.Aend=target.Aend AND source2.type=target.type) WHERE FM='Mobile';
>
> I haven't tried the above code but I hope it might point you in the right
> direction.
>
> To make things fast, don't forget to index your source* tables on
> (Aend,type) or something like that.
>
> Simon.
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users


[sqlite] Selective update of a column

2010-11-17 Thread Amit Chaudhuri
Hi all,

I can't work out how to do something I feel ought to be easy.  Attached
small file is designed to be .read to provide a test case.  Explanation of
what I'm trying to follows below.

I have two separate but very similar source data sets, one for mobile one
for fixed calls of various sub-types.  My target table has a column in
(defined as cost REAL) which I want to update based on the values in the
sources.

Target has a field in which allows me to distinguish mobile rows from fixed
call rows, plus a field which has the call sub-types in.

The approach I tried was to perform 2 sequential updates using first the
fixed call source table then the mobile. I tried to restrict the update to
rows in target where the class of call (fixed or mobile) corresponded to the
content of the source.

What seems to happen is that the second update blats the updates performed
by the first: I can have either fixed results or mobile results but not
both.

I'm pretty sure I'm doing something wrong but haven't been able to find
examples which show me how to resolve. Any pointers much appreciated...

Regards,


Amit

Version 3.7.3 on Windows XP

[For the time being I have split the target into two and done the individual
updates and reassembled.  Works - but can't quite believe it's the most
elegant solution]
/* Update one table with values from another

sources 1 & 2 represent fixed and mobile datasets.

table target contains mixed data



*/



drop table if exists source1;
create table source1 (

Aend TEXT,
type TEXT,
cost REAL


);


INSERT INTO source1 VALUES('ALF','TFD',1.0);
INSERT INTO source1 VALUES('ALF','DTF',2.1);
INSERT INTO source1 VALUES('ALF','CP',0.5);
INSERT INTO source1 VALUES('ALF','ITF',0.4);
INSERT INTO source1 VALUES('ALF','UIFN',0.760);
INSERT INTO source1 VALUES('ALF','SC',-1.0);



drop table if exists source2;
create table source2 (

Aend TEXT,
type TEXT,
cost REAL


);


INSERT INTO source2 VALUES('ALF','TFD',21.0);
INSERT INTO source2 VALUES('ALF','DTF',22.1);
INSERT INTO source2 VALUES('ALF','CP',20.5);
INSERT INTO source2 VALUES('ALF','ITF',20.4);
INSERT INTO source2 VALUES('ALF','UIFN',20.760);

drop table if exists target;
create table target (

Aend TEXT,
type TEXT,
FM TEXT,
cost REAL


);



INSERT INTO target VALUES('ALF','TFD','Mobile',0.0);
INSERT INTO target VALUES('ALF','UIFN','Mobile',0.0);
INSERT INTO target VALUES('ALF','DFT','Mobile',0.0);
INSERT INTO target VALUES('ALF','CP','Mobile',0.0);
INSERT INTO target VALUES('ALF','SC','Mobile',0.0);

INSERT INTO target VALUES('ALF','UIFN','Fixed',0.0);
INSERT INTO target VALUES('ALF','CP','Fixed',0.0);
INSERT INTO target VALUES('ALF','SC','Fixed',0.0);
INSERT INTO target VALUES('ALF','TFD','Fixed',0.0);



/* Syntax to update one table with values from another



*/
update target set cost = (select cost from source1 where 
source1.Aend=target.Aend and source1.type=target.type and FM='Fixed');

select * from target;

select "Split";

update target set cost = (select cost from source2 where 
source2.Aend=target.Aend and source2.type=target.type and FM='Mobile');


/* Highlight that the data in the cost column after the first update has been 
over-written by the second which was not what was required.

Implies that the only way to make the update process work (as opposed to using 
other joining techniques) is to partition the data set into separate fixed / 
mobile tables, perform separate updates and then recombine the updated data.


*/
select * from target;

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


Re: [sqlite] Create a GUI for interacting with a test questions sqlite db

2010-09-06 Thread Amit Chaudhuri
Arthur,

Nokia's Qt4 may be worth a look.

Amit

On Mon, Sep 6, 2010 at 7:51 AM, Arthur Avramiea wrote:

>
> Thank you very much for your answers. I already have mysql, php, c and some
> beginner c++ experience. Learning a new language wouldn't be about
> difficulty, but about time :). I am also considering java for it. What do
> you think? The pass doesn't have to be in plain text in the software ... I
> can store it as sha1 or other kind of hash. Wouldn't that solve most of it?
> Or some implementation of SSL.
> The software will be ran only by the course instructor so it will not have
> a
> big chance to get in the wrong hands. I want less exposure so that is why I
> want to avoid a web interface for it.
> --
> View this message in context:
> http://old.nabble.com/Create-a-GUI-for-interacting-with-a-test-questions-sqlite-db-tp29626091p29631420.html
> Sent from the SQLite mailing list archive at Nabble.com.
>
> ___
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users