Re: [sqlite] Statement cache does not play well with sqlite3_stmt_readonly

[gwenn]

Ok,
Thanks.

On Tue, Jun 3, 2014 at 8:42 PM, Richard Hipp  wrote:
> On Tue, Jun 3, 2014 at 2:27 PM, gwenn  wrote:
>
>> Hello,
>> The function "sqlite3_stmt_readonly" returns true/1 for the statement
>> "DROP TABLE IF EXISTS test" when the table "test" does not exist.
>> But, if this drop statement is cached, "sqlite3_stmt_readonly" still
>> returns true even after creating the table "test".
>> The only way I've found to make "sqlite3_stmt_readonly" returns false
>> is to execute/step the drop statement.
>> Do you know another way to make SQLite "reevaluate" the readonly status ?
>>
>
> Thank you for the bug report.
>
> Because this is a very minor issue and because we are well into the test
> cycle for version 3.8.5 already, we are going to defer looking into this
> problem until after the 3.8.5 release.
>
> --
> D. Richard Hipp
> d...@sqlite.org
> ___
> 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] Threads and System.Data.SQLite

[Simon Slavin]

On 3 Jun 2014, at 11:05pm, Drago, William @ MWG - NARDAEAST 
 wrote:

> "You May create multiple threads, and those threads can create their own 
> SQLiteConnection and subsequent objects for accessing a database.  Multiple 
> connections on multiple threads to the same database file are perfectly 
> acceptable and will behave predictably."
> 
> So I don't have to lock the section of code that writes to the database like 
> I do when I have multiple threads writing to a .csv file?

Probably easiest if you read this then post again if you still have questions.



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

[sqlite] Threads and System.Data.SQLite

[Drago, William @ MWG - NARDAEAST]

All,

In the Provider Limitations section of the SQLite.NET help file it says:

"You May create multiple threads, and those threads can create their own 
SQLiteConnection and subsequent objects for accessing a database.  Multiple 
connections on multiple threads to the same database file are perfectly 
acceptable and will behave predictably."

So I don't have to lock the section of code that writes to the database like I 
do when I have multiple threads writing to a .csv file?

Thanks,
--
Bill Drago
Senior Engineer

L3 Communications / Narda Microwave East
435 Moreland Road
Hauppauge, NY 11788
631-272-5947 / william.dr...@l-3com.com

CONFIDENTIALITY, EXPORT CONTROL AND DISCLAIMER NOTE:This e-mail and any 
attachments are solely for the use of the addressee and may contain information 
that is privileged or confidential. Any disclosure, use or distribution of the 
information contained herein is prohibited. In the event this e-mail contains 
technical data within the definition of the International Traffic in Arms 
Regulations or Export Administration Regulations, it is subject to the export 
control laws of the U.S.Government. The recipient should check this e-mail and 
any attachments for the presence of viruses as L-3 does not accept any 
liability associated with the transmission of this e-mail. If you have received 
this communication in error, please notify the sender by reply e-mail and 
immediately delete this message and any attachments.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Application with 'grid' form for entering table data wanted

[Stephen Chrzanowski]

By the sounds of it, the OP wants a spreadsheet app, that isn't a
spreadsheet app, acts like a database, but isn't quite a database, looks
simple to use, but provide editable information in a reasonable format.

To bring up a point about Google that RSmith brought up, Google Docs has a
spreadsheet app that has zero install, accessible by many (If you want) and
available from anywhere provided an internet connection is available, and
allows you to edit, search, sort, filter, and all the other bells and
whistles other spreadsheet and database applications have.  Mind you
linking an external data requester application might be a bit of a PITA (If
that is a requirement) might start throwing additional complexities into
the mix.

Since the LAMP setup is available, there are other spreadsheet type
applications that allow you to move from Google Docs to in-house.  Off the
top of my head I can't think of the names I've used in the past (I write
databases, not spreadsheets) but they are out there, free for all, just
short of public domain (MIT maybe?), and in a
'download-extract-run-configure' format usually, which is GREAT with a LAMP
setup.

The other option is to go ground up with PHP and some very basic AJAX
calls, but even then, you'd need SOME kind of management.  How many rows to
display, how many columns to display, do we add rows, remove rows, what
field is what cast, validation requirements, data storage considerations,
data VOLUME considerations, who accesses the data, what is read only and
who/what can write to the table, are we talking one database, one table,
one user, or, many databases, many tables, many users, does encryption come
into play and if so at what level?  Some kind of management HAS to happen,
like it or not.  And if basic management comes into play, you might as well
stick with something that already exists (Google Docs, OpenOffice,
LibreOffice, Excel, Notepad).

>From a mile high view, O.P., from a ground up build of an application
perspective, what you're requesting LOOKS simple, but there are a TONNE of
things to take into consideration that must happen in the back end.  Even
with forgetting about security, validation, and accessibility.  That stuff
just icing on the cake.

Take this example;

5x5 text field form.  That is 25 fields.  Each field has to have a unique
identifier.  Using the Spreadsheet format, A1:E5 is the range of cells.

Things to consider
- Is this a field to be calculated?
- Is this actually a number?
- Does the cell reference something else?

Code has to be written for that.

Two months later, you realize that 25 cells is just not enough info.  So
now we're looking at more rows, more columns, more data.  Is this going to
require a database rewrite?  Cells need to rely and reference other cells?
Forget the back end, how do we draw the UI?  Now we're throwing tabs into
the mix?  So now I have to deal with something in the range of AA1:RZ10?
How am I going to get a web page to throw 4420 cells on the screen AND make
it somewhat serviceable? (26*10*17=4420)

Two months later, you want to give read only access to someone else to view
your 4420 cells.  User authentication has to come into play.  oAuth, or
simple user/password?  We talking encryption at authentication, or for
authentication AND showing the UI?


On Tue, Jun 3, 2014 at 1:48 PM, RSmith  wrote:

> A very simple to use interface can be programmed with C# maybe which I am
> sure would have pre-made data grids. The dev system I use for Linux which
> definitely has all the bells and whistles and you can probably hack
> together the exact thing you mention in about 30 minutes is called Lazarus
> which is a kind of "Delphi for Linux" type thing which support most DBs
> natively (or easily addable) with grids and data connections/adaptors, but
> if I were you would go for a dev system I know well. Is there one you know
> well? A simple Google on it might find us some DB Grid type controls
> already made by someone (probably for use in some clever DB manager, but
> which you can re-appropriate in a more simplistic app).  Kevin's Gtk
> suggestion sounds like a plan that can be both relatively easy to implement
> /and/ easy to use, if you are familiar with that dev system and the
> intended users are not complete ignoramii.
>
>
>
> ___
> 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] Statement cache does not play well with sqlite3_stmt_readonly

[Richard Hipp]

On Tue, Jun 3, 2014 at 2:27 PM, gwenn  wrote:

> Hello,
> The function "sqlite3_stmt_readonly" returns true/1 for the statement
> "DROP TABLE IF EXISTS test" when the table "test" does not exist.
> But, if this drop statement is cached, "sqlite3_stmt_readonly" still
> returns true even after creating the table "test".
> The only way I've found to make "sqlite3_stmt_readonly" returns false
> is to execute/step the drop statement.
> Do you know another way to make SQLite "reevaluate" the readonly status ?
>

Thank you for the bug report.

Because this is a very minor issue and because we are well into the test
cycle for version 3.8.5 already, we are going to defer looking into this
problem until after the 3.8.5 release.

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

[sqlite] Statement cache does not play well with sqlite3_stmt_readonly

[gwenn]

Hello,
The function "sqlite3_stmt_readonly" returns true/1 for the statement
"DROP TABLE IF EXISTS test" when the table "test" does not exist.
But, if this drop statement is cached, "sqlite3_stmt_readonly" still
returns true even after creating the table "test".
The only way I've found to make "sqlite3_stmt_readonly" returns false
is to execute/step the drop statement.
Do you know another way to make SQLite "reevaluate" the readonly status ?
Thanks.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Application with 'grid' form for entering table data wanted

[RSmith]

On 2014/06/03 18:40, c...@isbd.net wrote:

RSmith  wrote:
Your requirement is unrealistic. You do not want to install anything that makes this happen for you, yet you want very complex 
abilities. 

MS Access provides *exactly* what I want 'out of the box' a
grid view of the database table that is editable in place.  What I see
as 'complex' is all the database adminstration bits that I
specifically don't want.

OK, I know Access is a huge application but the grid editing form is
the *default* way to edit data.


Yes but the bit you seem to not account for is that MS Access is a *Huge* app with a couple million lines of code underneath all 
that "easy to use" and "default" gridview that edits data. The fact that it is all transparent to you does not make it any less 
heavy. Moreover, if you are happy to install an MS-Access type App then there should be no problem, but you asked for something that 
does not need any installs. This is like saying "I would like to fly to France, but please, no aeroplanes" and when I say "well 
that's not realistic", you retort with "but it's so easy in a Boeing..." - to which I have to reply "Yeah I know, because it is an 
aeroplane and that is what aeroplanes do..." - you can't have it both ways.






Usually, presenting a very "clean" interface to a user requiring no other
interface goodies means that you need to do a lot of the
thinking for them - user simplicity means programming complicatedness,

Er no, I'm just asking for no other function than the ability to enter
and edit data.  What I want to be rid of is all of the ability that
most applications provide for creating tables, creating and editing
queries, changing tables, etc. etc.


Again, the "ability to enter and edit data" pre-supposes a lot of user interfacing and Insert and update queries, How do we know 
which row the user is editing, does the query provide the key. Is the user's input violating a subrange bound or maybe a check 
constraint or a data type constraint or possibly even a foreign key or Index uniqueness constraint? Is this new value an update or a 
new row, if it is an update, do we have a unique reference to the row or not, do we have a primary key, is the primary key editable 
or do we hide it?  Do we update after every value cell that was edited, if so we lose the ability to "undo" changes, is that ok? or 
do we update the entire row after it is edited, if so we need some kind of button/event on which to do it - does this add unwanted 
complexity? All this happens nicely for you in the back of an MS Access app (or any of the myriad DB editors out there) but they all 
are rather hefty and the LAMP system is a great example of how clunky it can get to do all of the above in a web app. Of course if 
your requirements can safely disregard all the above it could be very streamlined and easy to use, but we have to understand what 
abilities we lose in the process.






I already have a 'LAMP' system, i.e. a web server (with several apps
running on it), database, PHP, etc.  I don't mind installing things
but I don't want to have to 're-invent the wheel'.


I understand, but you are either re-inventing the wheel, or using an existing wheel. One takes time, the other requires an install, 
there is no middle road.




Both places where I want to run this are Linux boxes so a desktop application would be fine, however I have yet to see a desktop 
API that makes it easy to do this. 


I agree, but for reasons mentioned above, it isn't easy and anyone who usually starts out making an easy editor ends up making a 
complex one. By that I mean that there are a myriad SQL editors out there, many for linux desktops too, but each of them will allow 
you all kinds of editing and design function, lots more than you you want.


A very simple to use interface can be programmed with C# maybe which I am sure would have pre-made data grids. The dev system I use 
for Linux which definitely has all the bells and whistles and you can probably hack together the exact thing you mention in about 30 
minutes is called Lazarus which is a kind of "Delphi for Linux" type thing which support most DBs natively (or easily addable) with 
grids and data connections/adaptors, but if I were you would go for a dev system I know well. Is there one you know well? A simple 
Google on it might find us some DB Grid type controls already made by someone (probably for use in some clever DB manager, but which 
you can re-appropriate in a more simplistic app).  Kevin's Gtk suggestion sounds like a plan that can be both relatively easy to 
implement /and/ easy to use, if you are familiar with that dev system and the intended users are not complete ignoramii.



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

Re: [sqlite] Application with 'grid' form for entering table data wanted

[J Decker]

You didn't list C#(mono,silverlight(uhmm not sure what mono called it) for
web) in your repitroire; but a DataGridView filled from a DataAdapter is a
few lines of code to get a editable table view.
A few more lines and you get auto updating; cells are format protected
(prevent entering text as a number)...
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Application with 'grid' form for entering table data wanted

[Kevin Martin]

On 3 Jun 2014, at 15:07, c...@isbd.net wrote:

> I'm looking for an application (or *simple* development framework)
> which will provide me with an easily accessible grid form for entering
> data into a table.

I don't know anything about coding a web program, so all this advice related 
purely to a desktop application

It's possibly not what you're looking for, as it's a console application, but I 
think the spreadsheet calculator, sc, satisfies most of your requirements. The 
file format is very simple, so the plumbing to get data out of the table and 
back in should be fairly simple. If you need a quick solution that's _ok_ then 
I'd consider it. If you want a nice solution, then it will take the time to 
code something as someone else already pointed out.

If you are competent with Gtk, someone has kindly created a spreadsheet like 
widget called GtkSheet, embedding this in your won Gtk application shouldn't be 
too difficult.

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

Re: [sqlite] Application with 'grid' form for entering table data wanted

[cl]

RSmith  wrote:
> 
> On 2014/06/03 16:07, c...@isbd.net wrote:
> > I'm looking for an application (or *simple* development framework)
> > which will provide me with an easily accessible grid form for entering
> > data into a table.
> >
> > Requirements:-
> >  This can be a web app or a [Linux] desktop one though I have a
> >  slight preference for a web app.
> >
> >  Must be able to launch straight into the grid, no navigation
> >  through menus etc.  This rules out OpenOffice/LibreOffice really.
> >  I want to be able to say:-
> >  gridform  
> >  or the equivalent in a link.  A 'SELECT' in addition would be fine
> >  just as long as it can all be done in one go when launched (or
> >  linked to).
> >
> >  I want a 'clean' form, just the form, no menus or other clutter
> >  (similarly rules out OpenOffice/LibreOffice).
> >
> >  Simple 'in form' data editing, just click on a field and change
> >  its data, on exiting the field the data is saved.  No pop-up boxes
> >  for data entry, no 'Save' buttons.
> >
> >  Add rows at the bottom either by TABbing off the last field or
> >  possibly have a blank row at the bottom (like MS Access).
> >
> > That's it really, I've no need for the ability to add columns, modify
> > the database or anything like that (it will be done elsewhere).  I'm
> > happy to do some programming, I'm resonably proficient in PHP and
> > Python (and C/C++ for that matter but I don't think I want to go
> > there).  I don't really want to have to install a whole web (or other)
> > development framework just to do this though so I probably want
> > something that's specifically aimed at databases if I'm going to
> > program it.
> >
> 
> Your requirement is unrealistic.
> 
> You do not want to install anything that makes this happen for you, yet 
> you want very complex abilities. 
> 
MS Access provides *exactly* what I want 'out of the box' a
grid view of the database table that is editable in place.  What I see
as 'complex' is all the database adminstration bits that I
specifically don't want.

OK, I know Access is a huge application but the grid editing form is
the *default* way to edit data.


> Usually, presenting a very "clean" interface to a user requiring no other 
> interface goodies means that you need to do a lot of the 
> thinking for them - user simplicity means programming complicatedness, 

Er no, I'm just asking for no other function than the ability to enter
and edit data.  What I want to be rid of is all of the ability that
most applications provide for creating tables, creating and editing
queries, changing tables, etc. etc.


> and programming simple things means the user ends up with 
> complicated GUI methods. Which do you want, simple to make, or simple to 
> use? They are mutually exclusive. 
> 
> I have done this a few times, using mostly flash (which I can send you 
> demo log-ins for if interested) and in HTML5+PHP with a few 
> tricks you should be able to achieve similar if you are very familiar with 
> web/html/php development. (I say PHP but it's doable in 
> ASP.Net etc. too if needed). I do not know if installing a web server or 
> PEAR/PHP/ASP etc. services violates your "Don't want to 
> install stuff" requirement. Also, you cannot just load say 7 million edit 
> fields into an HTML file... it will fail miserably.. so 
> you will need to use data windowing (simplicity--).
> 
I already have a 'LAMP' system, i.e. a web server (with several apps
running on it), database, PHP, etc.  I don't mind installing things
but I don't want to have to 're-invent the wheel'.


> May I suggest plagiarising the open source MySQL viewer engine called 
> phpMyAdmin, 
> they have awesome generic table editors that 

I have phpmyadmin and use it a lot but it's *MILES* away from what I
want.  This is what I've been trying to explain, firstly I want none
of the database administration stuff, secondly I want it to be easy to
edit the data, in phpmyadmin editing data is clumsy.


> interfaces a MySQL DB on a web server based off PHP. Just install it onto 
> your local system, all the PHP files which achieve the 
> fields editing will be in one folder. It will take some work still.
> 
> A desktop App will be easy too, but only usable on whatever platform it 
> is made. Web apps can work anywhere. 
> 
Both places where I want to run this are Linux boxes so a desktop
application would be fine, however I have yet to see a desktop API
that makes it easy to do this.

-- 
Chris Green
·

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

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

[Richard Hipp]

On Tue, Jun 3, 2014 at 8:34 AM, Max Vlasov  wrote:

> Don't know what is difference between "stock" 3.8.4.3 from the site
> and the newly compiled one...
>

The official deliveries of 32-bit DLLs are normally cross-compiled on Linux
using MinGW 4.5.2.  But the most recent snaphost 32-bit DLL was compiled on
Win8 using VS2012.

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

Re: [sqlite] Application with 'grid' form for entering table data wanted

[RSmith]

On 2014/06/03 16:07, c...@isbd.net wrote:

I'm looking for an application (or *simple* development framework)
which will provide me with an easily accessible grid form for entering
data into a table.

Requirements:-
 This can be a web app or a [Linux] desktop one though I have a
 slight preference for a web app.

 Must be able to launch straight into the grid, no navigation
 through menus etc.  This rules out OpenOffice/LibreOffice really.
 I want to be able to say:-
 gridform  
 or the equivalent in a link.  A 'SELECT' in addition would be fine
 just as long as it can all be done in one go when launched (or
 linked to).

 I want a 'clean' form, just the form, no menus or other clutter
 (similarly rules out OpenOffice/LibreOffice).

 Simple 'in form' data editing, just click on a field and change
 its data, on exiting the field the data is saved.  No pop-up boxes
 for data entry, no 'Save' buttons.

 Add rows at the bottom either by TABbing off the last field or
 possibly have a blank row at the bottom (like MS Access).

That's it really, I've no need for the ability to add columns, modify
the database or anything like that (it will be done elsewhere).  I'm
happy to do some programming, I'm resonably proficient in PHP and
Python (and C/C++ for that matter but I don't think I want to go
there).  I don't really want to have to install a whole web (or other)
development framework just to do this though so I probably want
something that's specifically aimed at databases if I'm going to
program it.



Your requirement is unrealistic.

You do not want to install anything that makes this happen for you, yet you 
want very complex abilities.

Usually, presenting a very "clean" interface to a user requiring no other interface goodies means that you need to do a lot of the 
thinking for them - user simplicity means programming complicatedness, and programming simple things means the user ends up with 
complicated GUI methods. Which do you want, simple to make, or simple to use? They are mutually exclusive.


I have done this a few times, using mostly flash (which I can send you demo log-ins for if interested) and in HTML5+PHP with a few 
tricks you should be able to achieve similar if you are very familiar with web/html/php development. (I say PHP but it's doable in 
ASP.Net etc. too if needed). I do not know if installing a web server or PEAR/PHP/ASP etc. services violates your "Don't want to 
install stuff" requirement. Also, you cannot just load say 7 million edit fields into an HTML file... it will fail miserably.. so 
you will need to use data windowing (simplicity--).


May I suggest plagiarising the open source MySQL viewer engine called phpMyAdmin, they have awesome generic table editors that 
interfaces a MySQL DB on a web server based off PHP. Just install it onto your local system, all the PHP files which achieve the 
fields editing will be in one folder. It will take some work still.


A desktop App will be easy too, but only usable on whatever platform it is 
made. Web apps can work anywhere.


Not sure if this answers the question or raises more questions, either way I 
hope it helps a bit.


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

Re: [sqlite] Like and percent character

[Kevin Martin]

Are you forming your query with sprintf? It may be worth printing the query you 
are preparing, to make sure it says what you think it is.

Thanks,
Kev

Sent from my iPhone

> On 3 Jun 2014, at 14:53, Micka  wrote:
> 
> Hi,
> 
> I'm having trouble with the percent character .
> 
> 
> By example in my table I have :
> 
> id name
> 1 micka
> 2 mickael
> 
> I would like to do that :
> 
> Select * from table name where name LIKE '%micka%'
> 
> with my linux c program, the result is 0
> 
> but with the sqlite3 command program it works 
> 
> I also tested this :
> 
> Select * from table name where name LIKE 'micka%'
> 
> and this time, it works in my linux c program ...
> 
> Why ?
> ___
> 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] Like and percent character

[Hick Gunter]

Probably you are using a variant of the printf() function to generate your 
statement and it is interpreting the %m as strerror(errno)  (see man 3 printf), 
whereas it is ignoring %' (thousands separator for decimal conversions) either 
because it does not support this conversion or it is missing the conversion 
specifier.

Try inserting (3,'icka') into your table.

If it works in the shell but not in your program, then it is nearly always your 
program that is to blame.

-Ursprüngliche Nachricht-
Von: Micka [mailto:mickamus...@gmail.com]
Gesendet: Dienstag, 03. Juni 2014 08:58
An: sqlite-users@sqlite.org
Betreff: [sqlite] Like and percent character

Hi,

I'm having trouble with the percent character .


By example in my table I have :

id name
1 micka
2 mickael

I would like to do that :

Select * from table name where name LIKE '%micka%'

with my linux c program, the result is 0

but with the sqlite3 command program it works 

I also tested this :

Select * from table name where name LIKE 'micka%'

and this time, it works in my linux c program ...

I'm using the last package of sqlite3-dev ...
https://packages.debian.org/wheezy/sqlite3

Why ?

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


---
Gunter Hick
Software Engineer

Scientific Games International GmbH
Klitschgasse 2 – 4, A - 1130 Vienna,
Austria
FN 157284 a, HG Wien
Tel: +43 1 80100 0
E-Mail: h...@scigames.at

This e-mail is confidential and may well also be legally privileged. If you 
have received it in error, you are on notice as to its status and accordingly 
please notify us immediately by reply e-mail and then
delete this message from your system. Please do not copy it or use it for any 
purposes, or disclose its contents to any person as to do so could be a breach 
of confidence. Thank you for your cooperation.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Application with 'grid' form for entering table data wanted

[cl]

I'm looking for an application (or *simple* development framework)
which will provide me with an easily accessible grid form for entering
data into a table.

Requirements:-
This can be a web app or a [Linux] desktop one though I have a
slight preference for a web app.

Must be able to launch straight into the grid, no navigation
through menus etc.  This rules out OpenOffice/LibreOffice really.
I want to be able to say:-
gridform  
or the equivalent in a link.  A 'SELECT' in addition would be fine
just as long as it can all be done in one go when launched (or
linked to).

I want a 'clean' form, just the form, no menus or other clutter
(similarly rules out OpenOffice/LibreOffice).

Simple 'in form' data editing, just click on a field and change
its data, on exiting the field the data is saved.  No pop-up boxes
for data entry, no 'Save' buttons.

Add rows at the bottom either by TABbing off the last field or
possibly have a blank row at the bottom (like MS Access).

That's it really, I've no need for the ability to add columns, modify
the database or anything like that (it will be done elsewhere).  I'm
happy to do some programming, I'm resonably proficient in PHP and
Python (and C/C++ for that matter but I don't think I want to go
there).  I don't really want to have to install a whole web (or other)
development framework just to do this though so I probably want
something that's specifically aimed at databases if I'm going to
program it.



-- 
Chris Green
·

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

[sqlite] Like and percent character

[Micka]

Hi,

I'm having trouble with the percent character .


By example in my table I have :

id name
1 micka
2 mickael

I would like to do that :

Select * from table name where name LIKE '%micka%'

with my linux c program, the result is 0

but with the sqlite3 command program it works 

I also tested this :

Select * from table name where name LIKE 'micka%'

and this time, it works in my linux c program ...

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

[sqlite] Like and percent character

[Micka]

Hi,

I'm having trouble with the percent character .


By example in my table I have :

id name
1 micka
2 mickael

I would like to do that :

Select * from table name where name LIKE '%micka%'

with my linux c program, the result is 0

but with the sqlite3 command program it works 

I also tested this :

Select * from table name where name LIKE 'micka%'

and this time, it works in my linux c program ...

I'm using the last package of sqlite3-dev ...
https://packages.debian.org/wheezy/sqlite3

Why ?

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

[sqlite] Like and percent character

[Micka]

Hi,

I'm having trouble with the percent character .


By example in my table I have :

id name
1 micka
2 mickael

I would like to do that :

Select * from table name where name LIKE '%micka%'

with my linux c program, the result is 0

but with the sqlite3 command program it works 

I also tested this :

Select * from table name where name LIKE 'micka%'

and this time, it works in my linux c program ...

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

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

[Max Vlasov]

On Tue, May 27, 2014 at 10:49 PM, Richard Hipp  wrote:
> On Tue, May 27, 2014 at 10:50 AM, Richard Hipp  wrote:
>>
>
> This time I build the 32-bit DLL using mingw instead of MSVC.  (MSVC was
> still used for the 64-bit DLL.)  So perhaps it will work correctly on
> WinXP.  Please let me know one way or the other.  Thanks.
>

Don't know what is difference between "stock" 3.8.4.3 from the site
and the newly compiled one, but synthetic tests with memory databases
(no I/O involved) show that the new one is about 20% faster (Intel
Core i5-2310). If they're both MinGW built then probably some switch
differences between these builds (if there are any) gives such
difference.

Here is the schema and the timings. The first one is for
sqlite-dll-win32-x86-3080403.zip, the second one is for
sqlite-dll-win32-x86-201406021126.zip

The table in memory
  CREATE TABLE [TestTable] ([ID] Integer primary key, [IntValue]
INTEGER, [FloatValue] FLOAT, [StrValue] TEXT)

was populated  with 1000 pseudo-random rows using the same seed for
every test. The following queries all use cross join and differ in
types of data used (int, float, string)


Select Count(*) FROM (SELECT * FROM TestTable T1 Join TestTable T2 )
62 msec
47 msec

Select Count(*) FROM (SELECT *,t1.FloatValue / t2.FloatValue as
divvalue FROM TestTable T1 Join TestTable T2 where abs(divvalue -
round(divvalue)) > 0.499)
453 msec
359 msec

Select Count(*) FROM (SELECT * FROM TestTable T1 Join TestTable T2
where (T1.IntValue * T2.IntValue) % 1789 = 56)
203 msec
187 msec

Select Count(*) FROM (SELECT * FROM TestTable T1 Join TestTable T2
where substr(t1.strvalue, 1 + t1.intvalue % 20, 1 + t2.intvalue % 20)
= t2.strvalue)
499 msec
405 msec

Select Count(*) FROM (SELECT *,t1.FloatValue / t2.FloatValue as
divvalue FROM TestTable T1 Join TestTable T2 where abs(divvalue -
round(divvalue)) > 0.499 or (T1.IntValue * T2.IntValue) % 1789 = 56 or
substr(t1.strvalue, 1 + t1.intvalue % 20, 1 + t2.intvalue % 20) =
t2.strvalue)
1124 msec
952 msec


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