[sqlite] question about DB

I need to know if there are some order of penalty in attach (2+) databases to make a small (3 tables) join... (one table per DB). vs. (3 tables on same DB). I need it to get a small order concurrency writes... I have 3 process writting to one to each DB. but i need query everithing w

Re: [sqlite] sqllite db - remote access on a shared host

I know 3 desktop app... wich make an PHP tunnel to manage sqlite3 db... 1) Navigat SQL Free (has version for free) 2) SQL Maestro for sqlite (has version for free i think..) 3) Ems Manager for sqlite --- On Fri, 7/20/12, Kieran Hever wrote: > From: Kieran Hever > Subject: [sqlite] sqllit

[sqlite] sqlite as cache database

i'm working on a small ecommerce site for latin america.. http://comercialibre.com this website is using sqlite3 for store website pages as cache there are some burst of 60 concurrent users and sqlite is working great for this app layout.. __

Re: [sqlite] How efficient is this?

you can do: update t1 set (a,b)=(select a, b from t2 where t1.id=t2.id) just like oracle do --- On Thu, 3/8/12, Marc L. Allen wrote: > From: Marc L. Allen > Subject: [sqlite] How efficient is this? > To: "sqlite-users@sqlite.org" > Date: Thursday, March 8, 2012, 12:53 PM > I'm trying

[sqlite] Question about FTS

How can i know if my shared hosting PHP (sqlite 2 v2.8.17 "2.0-dev $Id: sqlite.c 298697 2010-04-28 12:10:10Z iliaa $" ) or my PDO (sqlite3 library v.3.3.7 "(bundled) 1.0.1 $Id: pdo_sqlite.c 293036 2010-01-03 09:23:27Z") support FTS ??? There are some chance to get FTS running without recompile

Re: [sqlite] my new site is using as backend sqlite

] my new site is using as backend sqlite On 14-07-2011 21:40, Sebastian Bermudez wrote: > i have this new micro site ready for my personal office > > http://urlit.tk > > > this site is using sqlite as backend > > please, don't smile !! this is very very m

[sqlite] my new site is using as backend sqlite

i have this new micro site ready for my personal office http://urlit.tk this site is using sqlite as backend please, don't smile !! this is very very micro site. for my personal url shorter function ___ sqlite-users mailing list sqlite

[sqlite] Index question about index

simple question: i have table tsamov create table tsamov ( tsamov_id integer not null primary key ,tsamov_descri text, ,tsamov_code text ) i have index on tsamov_code (it's varchar column of lenght=5) could the next query use the tsamov_code index ??: select * from tsamov where tsamov_c

[sqlite] Database Locked

I'm using sqlite v3 as database backend for an very small web app (some of 20 concurrent users -really serial access users-).. in Ms. Win xp (my test/develop env.) it work perfectly...my web app can handle that load(and even more by My JMeter Tests)... But on my production environment (L

[sqlite] Database Locked

I'm using sqlite v3 as database backend for an very small web app (some of 20 concurrent users -really serial access users-).. in Ms. Win xp (my test/develop env.) it work perfectly...my web app can handle that load(and even more by My JMeter Tests)... But on my production environment (L

Re: [sqlite] Query Problem when Executed from PHP v5.2.9-2

try : $strQuery ="SELECT CASE WHEN substr(substr(eTimeStart,1,2),-1) =\':\' THEN substr(eTimeStart,1,1)||substr(etimeStart,3,2) ELSE substr(eTimeStart,1,2)||substr(eTimeStart,4,2) END as aTIME FROM EVENTS WHERE Cast(eMonth as int)= 2 AND CAST(eYear as INT)=2010 and CAST(eDay as INT)=13 OR

[sqlite] Request Feature

each SELECT-FOR-UPDATE query when uploading the scripts..and undo when donwload the site Can You support the FOR UPDATE construction in a dummy mode ??? Att. Sebastian Bermudez PD: sorry i don't study english Yahoo! Cocina Encontra las mejores recetas con Yahoo! Cocina. http:

[sqlite] has used anyone sqlite for production web sites ??

i have an very small web site ( 60/80 Concurrent users )... running with mysql.. but i need transactions ( and my web hosting does not support innodb ) but have support for SQLITE 2.x & 3.x)... The web site has built with PHP using PDO.. the max..db-load for a requestis.

Re: [sqlite] how to represent a tree in SQL

look this: http://dev.mysql.com/tech-resources/articles/hierarchical-data.html is for mysql but aplies to every sql DB - Mensaje original De: Michael Chen Para: sqlite-users@sqlite.org Enviado: mié, octubre 14, 2009 10:40:45 AM Asunto: [sqlite] how to represent a tree in SQL Dear t

Re: [sqlite] In-memory database backup

you can attach a new slqite DB.. do insert into new_table_in_new_db select * from mem_table; deatach db - Mensaje original De: Andres Velasco Garcia Para: sqlite-users@sqlite.org Enviado: miércoles 30 de septiembre de 2009, 12:27:24 Asunto: [sqlite] In-memory database backup Hel

[sqlite] Ok. I found the error

i can't call sqlite3_column_type before sqlite3_step !! from sqlite.org: "...If the SQL statement does not currently point to a valid row, or if the column index is out of range, the result is undefined. These routines may only be called when the most recent call to sqlite3_step() has returned S

[sqlite] sqlite3_column_type bad value

i have 1 table: create table t1 ( id integer not null primary key, descri text ) then i exec... "SELECT * FROM t1" when i get the column type... with [ sqlite3_column_type(stmt,index); ] i get always (int)5 = SQLITE_NULL every else is correct !, i have the correct row count, field count; value

Re: [sqlite] SQLite Suitability for Shopping Cart

No ! use mysql that Concurrency on sqlite have high depend... from HW. (sqlite handles transaction one at time !)... 100 Concurrent Tx. (5 sec. each one)...the last pooled user must to wait 500 sec... to complete --- El mar 22-sep-09, CityDev escribió: > De: CityDev > Asunto: [s

Re: [sqlite] Question on converting objects into relational db

Objects maps to tables... fields maps to objects properties.. if you want just store all objects and read all objects create an entitites tables like: create table entity ( object as text ) and serialize that objects to database. --- El jue 10-sep-09, Shaun Seckman (Firaxis) escribió: >

[sqlite] Column MetaData

ok. i'm develop... an PHP-WEB Sqlite TUNNEL that PHP get a request, process it and send results to client (desktop app) In the client side, i have my Own Ado Like Data Access components my Question is: my cliente send a query "select * from tableA" the PHP exec the query and return an

Re: [sqlite] how to save image to sqlite..

i made it encoding image with base64... --- El lun 7-sep-09, Eka Rudito escribió: > De: Eka Rudito > Asunto: [sqlite] how to save image to sqlite.. > Para: sqlite-users@sqlite.org > Fecha: lunes, 7 de septiembre de 2009, 8:35 pm > hello there > > i am new bie in sqlite and this forum too.. >

Re: [sqlite] Slow SELECT query

1) Ok, change the index to: CREATE INDEX IF NOT EXISTS log_idx ON log (timestamp) column Id is not used for select... the Id column just is needed for delete operation. 2) what's log period your app.have ? Need Year ? Month ? Day ? can you change the REAL data type for an smaller one ? (integ

Re: [sqlite] Defining user groups in SQLite table

table groups ( group_id, group_descri ) table access ( rela_group, rela_code) --- El jue 3-sep-09, karenebs escribió: > De: karenebs > Asunto: [sqlite] Defining user groups in SQLite table > Para: sqlite-users@sqlite.org > Fecha: jueves, 3 de septiembre de 2009, 2:57 pm > > I have a databa

Re: [sqlite] Integer Storage class

__ > From: sqlite-users-boun...@sqlite.org > [sqlite-users-boun...@sqlite.org] > On Behalf Of Simon Davies [simon.james.dav...@googlemail.com] > Sent: Wednesday, September 02, 2009 9:05 AM > To: General Discussion of SQLite Database > Subject: Re

Re: [sqlite] Integer Storage class

> Fecha: miércoles, 2 de septiembre de 2009, 9:12 am > 2009/9/2 Sebastian Bermudez : > > hi! i have an table ( articles ) with a column for > EAN13 Barcodes like ( > > 7790080066784). > > I have created the column with Integer data type... ( > i have chose that da

[sqlite] Integer Storage class

hi! i have an table ( articles ) with a column for EAN13 Barcodes like ( 7790080066784). I have created the column with Integer data type... ( i have chose that data type after read the SQLITE DOC where it' say: "INTEGER. The value is a signed integer, stored in 1, 2, 3, 4, 6, or 8 bytes dependin