[sqlite] [ANN] New DBManager Professional Enterprise Edition 3.4.5

[COS]

DBTools Software is pleased to announce the new DBManager Professional
Enterprise Edition version 3.4.5.
This is only a bug fix without new features and recommended for users of
previous versions.

For a complete list of changes please check
http://www.dbtools.com.br/EN/article.php?id=00094.

The new version can be downloaded from
http://www.dbtools.com.br/EN/downloads/downloads_file.php?file_id=3

WHAT IS DBMANAGER?

DBManager Professional is a Windows application for complete database
management supporting MySQL, PostgreSQL, Interbase, Firebird, SQlite,
MSAccess, MSSQL Server, Oracle, Sybase, DBF Tables and ODBC Datasources. Its
features includes:

- Complete schema management
- Query Builder and Query Designer
- HTML Form and HTML Report Builders
- Diagram Designer
- Server and Database Monitoring tools with charts
- Serveral Wizards to Import and Export Structure and Data to/from a variety
of formats
- Task Builder for process automations
- And much more
- Available in English and Portuguese BR

For a complete list of features and versions available please check
http://www.dbtools.com.br/EN/dbmanagerpro.

Best Regards,

DBTools Software
http://www.dbtools.com.br


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Pragma table_info(), why no fields like UNIQUE, AUTOINCREMENT

[COS]

Hi,

- Original Message - 
From: "Stef Mientki" <[EMAIL PROTECTED]>
To: 
Sent: Tuesday, March 13, 2007 3:47 PM
Subject: Re: [sqlite] Pragma table_info(), why no fields like UNIQUE,
AUTOINCREMENT


> >
> >
> > You should also consider how your change might effect
> > backwards compatibility.  The last time that table_info()
> > was modified, the Ruby-On-Rails community got really
> > upset.  I'm rather of a mind to leave table_info() alone.
> >
> Forgive my ignorance, I'm just a beginner in databases,
> but what about TABLE_INFO2 ( ) ?
> (with the explicit restriction that it can be extended in the future
> when needed,
> so Ruby users leave it alone ;-)
> I really can't imagine that extension of a function can cause serious
> compatibility issues)
>
> The alternative is now that I've to
> - build a table from table_info()
> - query sqlite_master, to get the SQL string with which the table was
> generated
> - parse the SQL string from sqlite_master
> - and add it to my edit grid form table_info
> or are there simpler ways ?
>
> -- 
> cheers,
> Stef Mientki
> http://pic.flappie.nl
>

A small opinion on that matter: what I would really like to see is something
like system tables. Today sqlite uses only sqlite_master to keep information
about its objects and parsing is required to getter better info of each
object (if one needs to). Using other system tables to keep information
about each object seems very appropriated since most RDBMS already implement
that and it is compatible with SQL ANSI. I think it shouldn't be much of a
problem since sqlite engine already parses each object when it opens a
database. This would remove the need for PRAGMA commands and would make life
much simpler.

Just a thought.

Best Regards,

Crercio O. Silva / DBTools Software
http://www.dbtools.com.br


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

[COS]

Hi Rob,

You can try DBManager Standard or Enterprise Editions. The first one is free
for personal use, the second is a commercial product. The complete list of
features can be found at http://www.dbtools.com.br/EN/dbmanagerpro. You can
edit your tables data and also manipulate images in blob fields.

Another application from the same company is QueryIT. THis one is intended
to help people navigate through table records, which also includes master
detail records, generate charts, work with blob fields (show images).
Although this is a commercial product is very cheap in its category. For
more details see http://www.dbtools.com.br/EN/queryit.

Best Regards,

COS


- Original Message - 
From: "Rob Richardson" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, February 06, 2007 4:49 PM
Subject: [sqlite] Is there a SQLiteSpy-like thing that will let me change
data from a grid?


Greetings!

The only tool I have for examining and manipulating SQLite databases is
SQLiteSpy.  If I want to change data in that program, I have to write an
SQL statement.  Every other database editor I've seen lets a use do
simple things from a grid.  Open a table and data is loaded into a grid,
click on a cell and type in a value and it gets written to the table,
select a row and click a Delete button and the row is deleted from the
table, and so on.  There must be a tool somewhere that will do that for
a SQLite database, or there's some feature of SQLiteSpy I don't know
about.  Can somebody please point me to one or the other?

Thank you very much.

Rob Richardson


-
To unsubscribe, send email to [EMAIL PROTECTED]

-



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] New DBManager Released

[COS]

Hi,

DBTools Software is proud to announce the availability of the new DBManager
Professional Enterprise Edition 3.4.2 and DBManager Standard Edition 3.2.2.
For a complete list of changes please check our website at
http://www.dbtools.com.br/EN.

The new versions are available in our downloads center at
http://www.dbtools.com.br/EN/downloads.

What is DBTools Manager?

DBTools manager is an application for database managementm supporting MySQL,
PostgreSQL, Interbase, Firebird, SQlite, DBF Tables, MSAccess, MSSQL Server,
Sybase, Oracle and ODBC Datasources. This is a simple list of its features:

- Full object management
- Query Builder with planning, debugging capabilities
- Diagram Designer
- Report and Form Builders
- Lots of Wizards to import and export data/structure to/from a variety of
sources
- Database Documenter, Comparer and Migration Wizards
- View, Procedure and Function Builder
- English and Portuguese BR language resources available
- and much more

Available in two editions: Enteprise and Standard. The latest can be used
for free for personal use.
For a complete list of its features check
http://www.dbtools.com.br/EN/dbmanagerpro/features.php.

Best Regards,

DBTools Software
http://www.dbtools.com.br


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] New DBManager Standard Edition 3.2.1

[COS]

DBTools Software is pleased to announce the new DBManager Standard Edition.
This is a bug fix with some new features and improvements.
New Features and Improvements

  a.. Better support for SQlite Unicode databases
  b.. Now the Freeware Edition can load as many servers as available (1
Database Engine Only)
  c.. Added ContextMenu for Default Servers
  d.. Implemented AutoConfigureServers on first run
Fixes
  a.. crash when connecting to Workgroup when no catalog is opened
  b.. View Selected and Double Clicked in Objects Bar generated error
  c.. SQL Designer (Failed to added [View])
  d.. Firebird/Interbase not have autoinc on table designer
  e.. Procedure Builder was acumulating error messages on compilation
  f.. Server Manager didn't show default database
  g.. Server Manager Loosing some parameters when editing an existent
connection
  h.. several memory leaks
  i.. MySQL CreateIndex (missing columns quote)
  j.. Table Properties correctly shows foreign keys (PKTable was
empty/schema)
As requested by our users we have added a 20 day trial period, when you can
test all the features available in the Standard Edition. After the period
expires the application is automatically moved to Freeware Edition and you
can choose which engine to use when the application starts. The registration
is optional and at a very small fee.

The new version is now available in our Downloads Center at
http://www.dbtools.com.br/EN/downloads.

What is DBManager Standard Edition?

DBManager Standard Edition is a Windows application for database management.
It includes all the basic objects management, which is suitable for all
beginners. It supports MySQL, PostgreSQL, Interbase, Firebird, SQlite and
DBF Tables. For a complete list of features and screenshots please check
http://www.dbtools.com.br/EN/dbmanagerpro.

Best Regards,

DBTools Software
http://www.dbtools.com.br


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] SQLite GUI app that offers layouts

[COS]

Hi Tom,

- Original Message - 
From: "T" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Tuesday, October 17, 2006 9:47 PM
Subject: [sqlite] SQLite GUI app that offers layouts


> Hi all,
>
> There seem to be several SQLite GUI apps around. But I haven't seen
> any that offer building of layouts, ie positioning test frames for
> fields on a page for form data entry or printing. This feature is
> typical of proprietary apps such as FileMaker, AppleWorks, 4D etc.
>
> Anyone know of a GUI app that offers layouts (ie form creation),
> especially on a Mac (but even other platforms)?

DBManager Enterprise Edition (http://www.dbtools.com.br/EN/dbmanagerpro) can
do that. It has a form designer which allows to create and execute forms
like MSAccess does. This manager is for windows only and there is a TRIAL
Edition which you can test and see how it works.

> Is there a conventional way to store the layout information in the
> SQLite database itself, so it can be moved from one SQLite GUI app to
> another, and retain compatible forms?

I doubt you will find something like. Usually the form is handled only by
the GUI which created it. For example, you can't execute MSAcess forms on
any other GUI. Because of that it doesn't matter if the form is saved in the
SQLite DB or not, since most GUI's will not know what to do with it.

Hope that helps,

COS


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] [ANN] New DBManager Professional 3.4.0 Enterprise Edition

[COS]

DBTools Software is pleased to announce the new DBManager Professional 3.4.0
Enterprise Edition.
This is a major update with plenty of bugs fixed and new improvements to the
application. See the details:

NEW FEATURES AND IMPROVEMENTS

- Added Context Menu for Default Servers
- Diagram Designer (added option [Save] to table menu)
- Diagram Designer (added [*] mark when table is new)
- Implemented AutoConfigureServers on first run
- Objects are listed inside Namespace/Schema (If supported)
- Better support for SQlite Unicode databases
- ODBC now lists schemas/databases (if supported by the driver)

FIXES

- Fixed View Selected and Double Clicked in Objects Bar generated error
- Fixed SQL Designer (Failed to added [View])
- Fixed Oracle not showing View Columns
- Fixed Firebird/Interbase not have autoinc on table designer
- Diagram Designer (Fixed crash when dragging fields and changing name)
- Fixed Diagram Designer crash when create new table and drag column
with new name
- Procedure Builder accumulating error messages on compilation
- Fixed crash when connecting to Workgroup when no catalog is opened
- Fixed (Database missing when saving attached servers)
- Fixed Syntax error for INSERT MSAccess when column is image
- Fixed MySQL CreateIndex (missing columns quote)
- Fixed SQL Server Table copy did not SET IDENTITY_INSERT for inserts
- Fixed Diagram not asking to save before closing window
- Fixed Server Manager didn't show default database
- Fixed several memory leaks
- Fixed Server Manager Loosing some parameters when editing an existent
connection
- Fixed Server Manager loosing typed group when inserting new ODBC
connection
- Check ODBC Datatypes available when connecting (removed duplicates)
- Fixed Datasheet View now saves its layout
- Fixed Table Properties correctly shows foreign keys (PKTable was
empty/schema)
- Fixed ODBC not counting table rows when required
- Fixed MSSQL missing quotes when creating constraints
- Fixed Form did not show image for the first record

The current version  is now available in our Downloads Center
(http://www.dbtools.com.br/EN/downloads).

WHAT IS DBMANAGER?

DBManager Professional is a Windows application for database management,
with built-in support for Oracle, MSSQL Server/MSDE, Sybase, MSAccess,
MySQL, PostgreSQL, Interbase, Firebird, DBF Tables and ODBC Datasources. It
has all set of features which can include:

- Object Management (Database, Tables, Indexes, Foreign Keys, Check
Constraints, Domains, Views, Stored Procedures, etc)
- Query Editor and Query Builder with planner and debugger capabilities
- Database and Server Monitoring charts
- Diagram, Report and Form Designers
- Database Documenter (Printable and in HTML Format)
- Objects Browser (shows objects dependencies)
- Task Builder (to create complex tasks)
- Wizards to Import and Export Data including: Database Migration, MSAccess,
MSExcel, ODBC, Text Files (Delimited, Fixed), HTML, XML, Database Comparer
to synchronize structure
- and much more

For a full list of features please check
http://www.dbtools.com.br/EN/dbmanagerpro.

For a limited period of time we are offering a special price in our product
list, which makes it possible to purchase the Master Pack (which supports
all database engines) with discounts of 81%. For more details see
http://www.dbtools.com.br/EN/order.php.

Best Regards,

DBTools Software
http://www.dbtools.com.br



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] [ANN] New DBManager Standard Edition 3.2.0

[COS]

DBTools Software is pleased to announce the new DBManager Standard Edition
version 3.2.0.
This application replaces the old DBManager Freeware Edition (3.1.1) and it
can be used for FREE
in the following conditions:

- Personal use only

You can register the Standard Edition at any time you want and if you choose
to, at a very small fee.
Registered users will get the following additional features:

- Personal Use License restriction removed. You can use DBManager Standard
for commercial purposes
- Can manage multiple servers and multiple database engines. MySQL,
PostgreSQL, SQLite, Interbase,
  Firebird and DBF Tables
- Can execute queries on DBF Tables. Requires DAO 3.51 or later (usually
installed with Windows/Office)
- Can execute multiple statements queries
- Query/Procedure/View Editors with Planner and Debugger capabilities
- Picture viewer allow you to view image content from binary fields (Query
Editor and Datasheet)
- Can connect to Workgroup Servers
- Can connect to MySQL using the MySQL Webservice. Very soon other engines
will also have this feature builtin

The application is now available in our Downloads Center
(http://www.dbtools.com.br/EN/downloads).

What is DBManager?

DBManager is an application for Database Management available only for
Windows environments. Supporting the most popular database engines: MySQL,
PostgreSQL, Interbase, Firebird, SQlite, Oracle, MSAccess, MSSQL Server,
Sybase, ODBC and DBF Tables. To learn more about DBManager check out
http://www.dbtools.com.br/EN/dbmanagerpro.

MONTHLY SPECIAL OFFER

For limited time you will be able to benefit from our sales promotion.
During the promotion period you can purchase
any of our products with a considerable discount. To see all the details
check http://www.dbtools.com.br/EN/prices.php.
This promotion is valid for the following products:

- DBManager Professional Enterprise Edition (Open Source Pack and Master
Pack)
- DBManager Standard Edition
- DBTools QueryIT

Best Regards,

DBTools Software
http://www.dbtools.com.br



-
To unsubscribe, send email to [EMAIL PROTECTED]
-

[sqlite] New DBManager Professional 3.3.3 (Enterprise Edition)

[COS]

DBTools Software is pleased to announce the new DBManager Professional 3.3.3
Enterprise Edition.
This version is a major bug fix with a few extra funcionality added to the
application.

For a complete lists of changes check
http://www.dbtools.com.br/EN/article.php?id=00071.
You can download the latest version at
http://www.dbtools.com.br/EN/downloads.

What is DBManager?

DBManager is a commercial product for the Windows environment to manage
MySQL, PostgreSQL, Interbase, Firebird, SQlite, DBF, Microsoft Access,
Microsoft SQL Server, Sybase, Oracle and ODBC Datasources. It has a complete
set of Enterprise Features:

- Object Management (Including databases, tables, views, procedures,
functions, etc)
- Lots of wizards to Import and Export Structure and Data between databases
- Powerful Query and Procedure Builders, with multiple results and blob
viewer
- Form, Report and Diagram (ER) Designers
- Console
- Task Builder for process automations
- Server and Database Monitoring with charts
- and much more

For a complete list of features see
http://www.dbtools.com.br/EN/dbmanagerpro.

Best Regards,

DBTools Software
http://www.dbtools.com.br/EN


-
To unsubscribe, send email to [EMAIL PROTECTED]
-

Re: [sqlite] Charset-Confusions

[COS]

Anne,

- Original Message - 
From: <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, May 15, 2006 3:44 PM
Subject: [sqlite] Charset-Confusions


> An the 2. question: Is there any Really-Good-Admin-Tool to create
> DB and Table, to browse and maybe edit Fieldvalues in a grid?
> I have found 4 Admin-Programms. Some of them cannot open Version 3,
> some cannot differ Unicode and Multibytecharset, one of them has
> not a useful gui.
>
> Greetings from Germany
> Anne

Try DBTools Manager Professional at http://www.dbtools.com.br/EN/downloads.
It is very popular in the Open Sourced databases community  (It supports
many database engines). Its features can be compared with a mix of MSSQL
Server Enterprise Manager and MSAccess. It has a datasheet view to edit
table data with the following features:

- Capabilities for data paging: very good if your table has millions of data
- Capabilities to show images from blob fields as well as import/export
binary content
- Edit/Save, Filter and Order field capabilities
- Can be exported to HTML, XML, CSV and MSAccess

PS: For Windows only.

Check the page http://www.dbtools.com.br/EN/dbmanagerpro for a full list of
features.

Best Regards,

COS
>
> -- 
> GMX Produkte empfehlen und ganz einfach Geld verdienen!
> Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner
>

Re: [sqlite] SQLite :memory: performance difference between v2 and v3?

[COS]

Hi,

- Original Message - 
From: "Dennis Cote" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Thursday, May 04, 2006 2:27 PM
Subject: Re: [sqlite] SQLite :memory: performance difference between v2 and
v3?


> All,
>
> More mysteries. To investigate this low insert performance under WinXP I
> wrote a simple test program that loops writing one character to a file
> and then flushing the file. The strange thing is that it seems to
> alternate between two different run times as shown below. This is for 6
> consecutive runs.

If you are using WinXP with Service Pack 2 this can be the problem. I have
experienced a lot of issues with the Windows XP Firewall. The funniest (or
strangest) thing I have found so far is that the Firewall seems to block
certain things even if it is deactivated. The problem gets a lot worse if
you use an Anti-Virus software. In my case I use Viruscan and although I
unchecked all the options to check TCP/IP connections, emails, etc it still
slows my network traffic down. If I disable it everything works perfectly.
For example I work with mysql and connections to query data from the server
(another PC in local network) takes forever when Viruscan is active.

Just some thoughts.

Best Regards,

COS

[sqlite] [ANN] DBManager Professional 3.3.0

[COS]

DBTools Software is pleased to announce the availability of the new
DBManager Professional 3.3.0 Enterprise Edition. This release brings a lot
of new features and lots of improvements and bug fixes. See the short list
below:

- New Visual Interface
- New Procedure Builder with support for Functions and Triggers
- New Form Designer, now supporting subforms, menus and images inplace
- Diagram Designer redesigned
- Table Designer was remodeled and now includes information about the table
changes before commit
- Database Dump Wizard has plenty of new options. One particular is the
possibility to create a dump for older versions. This is useful if one needs
to dump and reload the database into different server versions
- Implemented Drag & Drop operation for extended objects like: Stored
Procedures, Functions, Views, etc
- Query Builder has being redesigned to add more useful information about
queries and other objects as well as allow editing external queries
- Many improvements and bugs fixed

The full list of changes can be viewed at
http://www.dbtools.com.br/EN/article.php?id=00062.

To download the new version go to http://www.dbtools.com.br/En/downloads.

What is DBManager Professional?

DBManager is a Windows application for database management. It supports
MySQL, PostgreSQL, Interbase, Firebird, SQlite, DBF Tables (Clipper, DBase
III, IV, V, FoxPro), MSAccess, MSSQL Server/MSDE, Oracle, Sybase and ODBC
Datasources (read only).
Among its features you will find:

- Complete database structure management for Tables, Indexes, Foreign Keys,
Check Constraints, Triggers, Domains, Stored Procedures, User Defined
Functions, Schemas/Namespaces, Tablespaces, etc
- Query Builder and Query Designer to build and test queries, with features
like: codesense and codetip, syntax coloring editor, help on SQL/DDL/DML
commands, results with blob shown as image, Query Planner and Debugger
- Procedure Builder (Extended from Query Builder) to develop and test Stored
Procedures, Functions, Triggers and Views
- Diagram Designer to visually create database diagrams
- Form and Report Builders
- Database Compare to synchronize database structure
- Lots of wizards to import and export data. From MSAccess, ODBC, MSExcel,
HTML, XML, Text CSV, Text Fixed to any of the database engine supported by
DBManager
- Database Migration Wizard to move structure and data between databases
- Database Control Version System: catalog your database versions and create
DDL files with a complete database or just the difference between versions
- Web Script Generator, a wizard to create script for the web in PHP and ASP
- And much more

For more details on DBManager Professional check
http://www.dbtools.com.br/EN/dbmanagerpro

Best Regards,

DBTools Software
http://www.dbtools.com.br

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

[COS]

Hi Jens,

> If you're coding against the 'standard' Win32 APIs, Windows will send
> you the strings in the character encoding specified by the either
> the  System or the current user settings. This has nothing to do with
> unicode. However, for many roman characters, the standard Windows
> code pages and UTF-8 have a fair amount of overlap, so you can get
> away just passing those strings to sqlite3_open() for ASCII names and
> _some_ localized names, but in general, this won't work if the
> filename is not pure ASCII.
>
> If you can't use the Win32 unicode APIs (in which case you'd call
> sqlite3_open16), you'll need to make sure you convert from the
> Windows encoding to UTF-8 before passing the filenames.
> Unfortunately, I don't know enough details about the Windows APIs to
> tell you exactly how to do this :(  You'll have to look up on MSDN -
> searching for "MultiByteToWideChar" might get you started...
> (I'm lucky enough to code on Mac OS X, where filenames are generally
> passed in UTF-8 ;-)

Thanks for the clarification. This information got me to the right
direction. I have found the "MultiByteToWideChar" function. It does what I
need. But instead of making conversions I decided to use the "IsTextUnicode"
function (I didn't know that one either) which provides far more information
about the string. If it returns true then I can safely (I suppose) use the
sqlite3_open16 to open the database. In my tests it worked perfectly, but I
guess the best way to really test this is asking some of our users to do so.
;-)

Thanks a lot for your time and help on this. You really helped me a lot.

Best Regards,

COS

Re: [sqlite] Using sqlite3_open or sqlite3_open16?

[COS]

Hi Jens,

- Original Message - 
From: "Jens Miltner" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Monday, April 24, 2006 5:30 AM
Subject: Re: [sqlite] Using sqlite3_open or sqlite3_open16?


>
> Am 22.04.2006 um 15:48 schrieb COS:
> > Thanks for the info. I did have found in the manual that UTF16 is
> > converted
> > to UTF8 on Windows environments.
> > But one little question: How would one know if the filename is in
> > UTF8 or
> > UTF16?
> > You see, my little application is installed in PC's all around the
> > world. I
> > don't know in advance if the filename is UTF8 or UTF16. I noticed that
> > always using UTF16 to open the database can lead to an exception in
> > filenames with UTF8.
>
> Hmmh - I'm not sure I entirely understand your problem: usually
> strings passed in UTF-16 are passed in 'wide' strings, i.e. each
> character is 16 bit as opposed to UTF-8 strings, which are usually
> passed in strings where each character is 8 bit.
> I don't know the Windows APIs very well, but from what I remember,
> you build your app either as Unicode app or as "ASCII" app and only
> unicode apps get their filenames as UTF-16, "ASCII" apps get whatever
> code page is installed/activated on the system, usually not UTF-8,
> though...

My application is not built using Unicode. But I use a lot of MFC and
CString is aware of International characters. The problem is a little
different. I don't need to use UTF16 strings at all. The problem comes up
when the application is started and it needs to open the database from the
My documents folder. In Windows NT/2000/XP and probably others too, the
userid is a string to compose the personal folder location (i.e.
C:\Documents and Settings\userid\My Documents). As you can see this location
can change a lot. It may even work for a particular user and don't for
another.

> Where do you get your filenames from so you don't know the encoding?

I get this information directly from Windows, using the Win32 SDK API. The
string is correct, even for UTF16 strings. The Windows SDK API allows to
open the file directly without problems or any conversion (maybe some
conversion is done internally by the Win32 SDK).

> As a rule of thumb: anything you get as a plain character pointer
> probably isn't UTF-16 (unless there's some badly designed API in the
> middle). OTOH, you can't assume anything that's plain character
> pointer is UTF-8 - most likely on Windows it's something different.
>
> 

I tried to look for some information in the MSDN, without success. I'm
starting to look at SQlite code to find out how the conversion is made and
maybe I can simulate the same process before opening the file and choose the
proper way.

Thanks for your time on this.

Best Regards,

COS