Re: [sqlite] GUI design & managment tool?

[Alex Mandel]

Allen Fowler wrote:
> Hello,
> 
> Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for 
> creating and maintaining an SQlite databases that can run on both Windows and 
> Linux?
> 
> (Support for visual relation design would be great, too.)
> 
> I found a list at:
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
> 
> But, I was wondering if anyone has personal experience to share...
> 
> Thanks,
> :)
> 

I usually use a UML diagram tool to draw the database to begin with and
run some scripts to convert it to SQL.
I've done it with Dia in the past which has a Dia2Code plugin but have
also heard good things about ArgoUml.

For ongoing management I use Firefox SQLite Manager plugin, and
spatialite-gui.

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

Re: [sqlite] GUI design & managment tool?

[BareFeet]

Hi Allen,

> Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool  
> for creating and maintaining an SQlite databases that can run on  
> both Windows and Linux?
>
> (Support for visual relation design would be great, too.)

I've posted a detailed comparison of various SQLite GUI browsers here:
http://www.tandb.com.au/sqlite/compare/?ml

It focuses on tools for Mac but some of the apps shown are also  
available for other platforms.

Tom
BareFeet

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

Re: [sqlite] GUI design & managment tool?

[Shaun Seckman (Firaxis)]

I've tried many free tools as well as shareware tools.  Here are my two
favorites and why:

SQLite Manager for Firefox, Thunderbird, etc:
http://code.google.com/p/sqlite-manager/
This one is simply amazing!  It does everything I want, supports
multiple platforms and is completely free.  It doesn't include any nice
new user features like a query builder and what not but it includes
everything an end user would need to view/manage their database.  After
using this I stopped looking.


SQLite Maestro: http://www.sqlmaestro.com/products/sqlite/maestro/
This is a shareware tool that is free for 30 days.  This tool is
very good and does everything you would expect a SQL database tool to
do.  One of my subtle gripes with it however is how it displays certain
data.  I have many many several text-type foreign keys and instead of
displaying the text value, it displays it as "MEMO".  Other than that
though the tool is much better than any others I've tried prior to
Firefox's plugin.

-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Allen Fowler
Sent: Tuesday, August 04, 2009 10:50 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] GUI design & managment tool?


Hello,

Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for
creating and maintaining an SQlite databases that can run on both
Windows and Linux?

(Support for visual relation design would be great, too.)

I found a list at:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

But, I was wondering if anyone has personal experience to share...

Thanks,
:)


  

___
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] Data synchronization between two offices

[Rich Shepard]

On Tue, 4 Aug 2009, Rstat wrote:

> But today we sell more and more books and the addition of a database means
> we need to synchronize our data from the warehouse database to the main
> office one, mainly to be able to know what kind of stock we have. I think
> we will have to go with a batch syncing scheduled twice a day for now. We
> have been dealing with Talend open studio so far and enjoy the product.

   I've not used talend, but it may work as an interim solution. What you
might think about as a scalable long-term solution is building a Web-based
application. You set up httpd with SQLite in the office, build the
application with Python/Django or Ruby on Rails, and you're set to go.
Anyone with a computer, Web browser, and connection to the 'Net can access
the data.

   You can have multiple terminals in the warehouse and various users in the
offices all accessing the information at their convenience. By having
different user categories, each with different priviledges, you can meet
everyone's needs and increase data integrity. For example, senior management
might be able to view data and reports but not enter or edit anything.
Receiving clerks can enter new inventory but not change records once entered
(that's up to a foreman or supervisor). Sales are entered either directly
from your Web site or someone in the office and both a pick list and invoice
are generated.

   Not only does this approach add capabilities and flexibility, but this
kind of control can support the SEC enforcement of your company executive's
compliance with the Sarbanes-Oxley Act. They can demonstrate fiscal control
and probity quite easily.

Rich

-- 
Richard B. Shepard, Ph.D.   |  IntegrityCredibility
Applied Ecosystem Services, Inc.|Innovation
 Voice: 503-667-4517  Fax: 503-667-8863
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Data synchronization between two offices

[Rstat]

Hi everyone, 

After building a database for our growing company, we have a problem with
our data and its synchronization. Our company has a rather small, but
growing, book warehouse and sells books online. We have been able to deal
with orders and stock because sales were not that large. 

But today we sell more and more books and the addition of a database means
we need to synchronize our data from the warehouse database to the main
office one, mainly to be able to know what kind of stock we have. I think we
will have to go with a batch syncing scheduled twice a day for now. We have
been dealing with Talend open studio so far and enjoy the product. 

Do you think Talend will be able to stand that type of operation? What kind
of software could be used in this case? 

Thanks all!
-- 
View this message in context: 
http://www.nabble.com/Data-synchronization-between-two-offices-tp24810303p24810303.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] GUI design & managment tool?

[Allen Fowler]

Hello,

Can anyone recommend a Free, or reasonably priced Non-Free, GUI tool for 
creating and maintaining an SQlite databases that can run on both Windows and 
Linux?

(Support for visual relation design would be great, too.)

I found a list at:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools

But, I was wondering if anyone has personal experience to share...

Thanks,
:)


  

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

Re: [sqlite] New group_split() function as inverse of group_concat()

[Igor Tandetnik]

Alexey Pechnikov wrote:
> Can somebody to show example of the group_split() function?
> PRAGMA can return rowset but how to do this in user functions?

I'm pretty sure SQLite doesn't support that.

Igor Tandetnik



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

Re: [sqlite] help with inconsistent results and segfault

[Pavlos Christoforou]

Thanks Dan much appreciated

We are using 3.6.2 (the standard version on our ubuntu machines). We will 
upgrade to 3.6.16

Regards

Pavlos 

- "Dan Kennedy"  wrote:
> On Aug 4, 2009, at 4:58 AM, Pavlos Christoforou wrote:
> 
> > Hello all,
> >
> > We are currently evaluating sqlite for using it as the
> > base engine for a financial reporting module. We have some
> > fairly complex queries which yield strange results. We have
> > tried to isolate the problem below. Please see select queries
> > at the end and associated comments which detail the issue:
> 
> Which version are you using? The output of running this script
> with 3.6.16 here is:
> 
>x|cum_sum_x|total
>10.0|10.0|110.0
>10.0|20.0|110.0
>20.0|40.0|110.0
>30.0|70.0|110.0
>40.0|110.0|110.0
>x|cum_sum_x|total
>10.0|10.0|110.0
>10.0|20.0|110.0
>20.0|40.0|110.0
>30.0|70.0|110.0
>40.0|110.0|110.0
>sum(x)
>110.0
>sum(x)
>110.0
>SQL error near line 64: misuse of aggregate: max()
> 
> Dan.
> 
> > ===
> >
> > create table Test (x FLOAT);
> >
> > insert into Test values (10);
> > insert into Test values (10);
> > insert into Test values (20);
> > insert into Test values (30);
> > insert into Test values (40);
> >
> >
> > create view TestViewWeird
> > as
> > select max(t1.x) as x,
> >   sum(t2.x) as cum_sum_x,
> >   -- bad sql below but is should yield consistent results IMO
> >   (select sum(x) from Test) as total
> > from Test as t1 inner join Test as t2
> > on t2.oid <= t1.oid
> > -- only difference is expression below
> > and total * t1.x > 0
> > --
> > group by t1.oid
> > ;
> >
> > create view TestView
> > as
> > select max(t1.x) as x,
> >   sum(t2.x) as cum_sum_x,
> >   -- bad sql below but is should yield consistent results IMO
> >   (select sum(x) from Test) as total
> > from Test as t1 inner join Test as t2
> > on t2.oid <= t1.oid
> > -- only difference is expression below
> > and (select sum(x) from Test) * t1.x > 0
> > --
> > group by t1.oid
> > ;
> >
> >
> > create view TestViewSegFault as
> > select max(t1.x) as x,
> >   sum(t2.x) as cum_sum_x,
> >   -- only difference is expression below
> >   max((select sum(x) from Test)) as total
> > from Test as t1 inner join Test as t2
> > on t2.oid <= t1.oid
> > and total * t1.x > 0
> > --
> > group by t1.oid
> > ;
> >
> >
> > .headers on
> >
> > -- below queries yield exactly the same results
> > select * from TestView;
> > select * from TestViewWeird;
> >
> > -- the first query below returns a value but the second returns a  
> > null.
> > select sum(x) from TestView;
> > select sum(x) from TestViewWeird;
> >
> > -- below seg faults
> > select * from TestViewSegFault;
> >
> > ==
> >
> > what are we doing wrong? Any help or pointers to appropriate docs  
> > will be greatly appreciated.
> >
> > Thanks
> >
> > Pavlos
> > ___
> > 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] New group_split() function as inverse of group_concat()

[Alexey Pechnikov]

Hello!

Can somebody to show example of the group_split() function? 
PRAGMA can return rowset but how to do this in user functions?

Best regards, Alexey Pechnikov.
http://pechnikov.tel/
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Disk I/O error on AIX

[Ken]

Roger,

Thats too funny. I guess I forgot posting this last year.

Ken

--- On Mon, 8/3/09, Roger Binns  wrote:

> From: Roger Binns 
> Subject: Re: [sqlite] Disk I/O error on AIX
> To: "General Discussion of SQLite Database" 
> Date: Monday, August 3, 2009, 7:55 PM
> Ken wrote:
> > I'm getting a Disk I/O error when committing a
> transaction on an AIX system.
> > The file system is JFS.
> > The extended result code is 1290. Which i believe
> means that the extended code is a SQLITE_IOERR_DIR_FSYNC
> error.
> > 
> > Any ideas why this is happening or how to track it
> down?
> 
> This has come up before and you may recognise the poster:
> 
>    http://thread.gmane.org/gmane.comp.db.sqlite.general/39682/
> 
> Roger
> 
> ___
> 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] Disk I/O error on AIX

[Ken]

Thanks Dan!

I'll check this in the morning.

Ken

--- On Tue, 8/4/09, Dan Kennedy  wrote:

> From: Dan Kennedy 
> Subject: Re: [sqlite] Disk I/O error on AIX
> To: "General Discussion of SQLite Database" 
> Date: Tuesday, August 4, 2009, 12:03 AM
> 
> On Aug 4, 2009, at 5:11 AM, Ken wrote:
> 
> >
> > Hi,
> >
> > I'm getting a Disk I/O error when committing a
> transaction on an AIX  
> > system.
> > The file system is JFS.
> >
> >
> > The extended result code is 1290. Which i believe
> means that the  
> > extended code is a SQLITE_IOERR_DIR_FSYNC error.
> >
> > Any ideas why this is happening or how to track it
> down?
> 
> AIX needs -DSQLITE_DISABLE_DIRSYNC.
> 
> Dan.
> 
> ___
> 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