[sqlite] ANN: SQLite Maestro 16.11 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 16.11, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Top 10 new features = 1. Support for the FTS5 extension. 2. Support for indexes on expressions. 3. A number of new encryption algorithms in data grids. 4. Custom SQL scripts for secondary database connections. 5. Improved Data Input Forms. 6. Support for Adobe Reader DC in BLOB Editor. 7. Ability to import blank values as empty strings. 8. Default application-level Data Import settings. 9. A number of new SQL Editor options. 10. Some performance and usability improvements. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_16_11_released/ Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 16.9 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 16.9, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demos: http://demo.sqlmaestro.com/feature_demo/ http://demo.sqlmaestro.com/nba/ Top 20 new features: 1. Column Filtering. 2. Custom Form Layouts. 3. Enhanced Master/Detail Views. 4. Record comparison. 5. Multi-Row Column Headers. 6. Breadcrumb navigation. 7. Automatic generation of index pages. 8. On-the-Fly Adding New Items to Lookup Controls. 9. Improved Filter Builder. 10. Quick Edit. 11. Adding multiple records from a single Insert form. 12. Geo Charts. 13. Permissions and RLS for all-level Details. 14. Flexible card views. 15. Enhanced JavaScript API. 16. OnGetCustomExportOptions event. 17. OnGetCustomUploadFileName event. 18. Built-in Lightbox component for external images. 19. Simple Data Grid Styling. 20. A number of GUI improvements. Full press-release is available at: http://www.sqlmaestro.com/news/company/php_generators_16_9_released/ Background information: --- SQL Maestro Group offers complete database management and web development tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 16.3 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 16.3, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ Video tour: https://www.youtube.com/playlist?list=PL4XOgRu7Vck8B7wRj6XqwVL4NPZzWGAHH Top 10 new features: 1. Out-of-the-box Charts. 2. Enhanced sidebar menus. 3. Compact themes. 4. Embedded Video support. 5. Customizable success/error messages. 6. Enhanced data export tools. 7. Custom form titles. 8. Event management enhancements. 9. Detailed descriptions. 10. PHP configuration settings. Full press-release is available at: http://www.sqlmaestro.com/news/company/php_generators_16_3_released/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com
[sqlite] ANN: SQLite PHP Generator 15.12 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 15.12, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ Top 15 new features: 1. New modern look and feel. 2. 100% responsive design. 3. PHP 7 support. 4. Top side drop-down menus. 5. Enhanced Filter Builder. 6. Multi-column sorting. 7. Keyboard shortcuts. 8. A number of new and updated controls. 9. 18 color themes. 10. Font-based icons. 11. Event management enhancements. 12. Less preprocessor syntax for user-defined styles. 13. HTML filter. 14. New and updated data access drivers. 15. PHP Generator UI improvements. Full press-release is available at: http://www.sqlmaestro.com/news/company/php_generator_15_12_released/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com
[sqlite] ANN: SQLite Maestro 15.1 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 15.1, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Top new features = 1. Support for user authentication and management. 2. Read-only database connections. 3. Improved table recreation SQL script. 4. Support for the COLLATE clause in SQL Formatter. 5. Colored tabs and more informative tab hints. 6. Customizable output columns for data export. 7. Some performance and usability improvements. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_15_1_released/ Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 14.10 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 14.10, a powerful GUI frontend for Windows that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ SQLite PHP Generator comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/sqlite/phpgenerator/feature_matrix/ Top 10 new features: 1. New and updated controls. 2. Enhanced JavaScript API. 3. New security-related features. 4. Extended template management. 5. Multi-group menus. 6. New application-level events. 7. Custom CSS and JavaScript. 8. Usability improvements. 9. PHP Generator UI enhancements. 10. Support for PHP 5.6 and other core features. Full press-release is available at: http://www.sqlmaestro.com/news/company/php_generators_advanced_to_version_14_10/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 14.3 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 14.3, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Top 10 new features = 1. Support for WITHOUT ROWID tables. 2. Improved constraint management. 3. Support for various data storage modes. 4. New Nullable Column Checker tool. 5. Enhanced Get SQL Dump wizard. 6. Optimized metadata modifications. 7. Data import from several files to a single table. 8. Advanced Column Builder for text files with fixed column width. 9. Data export to the JSON format. 10. Highlighted required columns in data grids. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_14_3_released/ Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Data Wizard 13.12 released
Hi! SQL Maestro Group announces the release of SQLite Data Wizard 13.12, a powerful Windows GUI solution for SQLite data management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/datawizard/ SQLite Data Wizard provides you with a number of easy-to-use tools to transfer any database to SQLite, import data into SQLite tables, export data from tables, views and queries to most popular file formats, dump table data to SQL files as well as generate data-driven ASP.NET pages for your SQLite database. Please note that before the end of the year you can purchase all our products and bundles with a 25% discount. Happy Holidays! http://www.sqlmaestro.com/purchase/ Top 10 new features = 1. Data Import: sending of email notifications with attached log files after the importing. 2. Data Import: loading data from several files to a single table. 3. Data Import: redesigned Column Builder for text files with fixed column width. 4. SQL Dump: renaming and reordering output columns. 5. SQL Dump: changing SQL syntax for the result scripts. 6. Data Pump: improved default data type mapping. 7. Data export to the JSON format. 8. Keyboard-interactive SSH authentication. 9. All the wizards now store their size and position. 10. New Start Page with comfortable access to program features. Full press-release is available at: http://www.sqlmaestro.com/news/company/data_wizards_advanced_to_version_13_12/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Code Factory 13.9 released
Hi! SQL Maestro Group announces the release of SQLite Code Factory 13.9, a powerful Windows GUI solution for querying SQLite databases and managing the data. http://www.sqlmaestro.com/products/sqlite/codefactory/ Please note that before Oct 13 you can purchase all our products and bundles with up to 25% discount. Please find details at http://www.sqlmaestro.com/purchase/ Top 10 new features: 1. Improved SQL Editor. 2. Updated SQL Dump wizard. 3. Keyboard-interactive SSH authentication. 4. New Start Page with quick access to recently connected databases. 5. Data import from several files to a single table. 6. Data export to the JSON format. 7. Enhanced data grids. 8. The Script Runner tool. 9. Colored profiles in Database Explorer. 10. New modern progress windows. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/codefactories_updated_to_13_9/ Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQL Anywhere, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: AnySQL Maestro 13.2 released
Hi! SQL Maestro Group announces the release of AnySQL Maestro 13.2, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (SQLite, PostgreSQL, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql/maestro/ AnySQL Maestro comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/anysql/maestro/free_vs_pro/ Top 10 new features: === 1. The software has been optimized to work with some popular DBMS including SQLite. 2. Updated Connection String Reference. 3. Enhanced Get SQL Dump wizard. 4. New Start Page with quick access to recently connected databases and latest company news. 5. Improved SQL Editor. 6. Highlighted key and required columns and multi-column lookup editors in the data grids. 7. Data import from CSV files containing multi-line strings. 8. Data Export: support for custom separators. 9. Colored profiles in Database Explorer. 10. New modern progress windows. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/anysql_maestro_13_2_released/ Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQL Anywhere, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 12.11 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 12.11, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Top 10 new features = 1. Enhanced full text search table management. 2. Support for XML and GUID data types. 3. Report Designer. 4. New Start Page with quick access to recently connected databases. 5. Improved SQL Editor. 6. Inline images, highlighted keys and multi-column lookups in data grids. 7. Data import from CSV files containing multi-line strings. 8. Updated SQL Script Editor and Script Runner tools. 9. Colored profiles in Database Explorer. 10. New modern progress windows. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_12_11_released/ Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 12.8 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 12.8, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ SQLite PHP Generator comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/sqlite/phpgenerator/feature_matrix/ Please note that before Sep 2 you can purchase the Professional Edition of SQLite PHP Generator as well as all other our products and bundles with a 20% discount. Top 10 new features: 1. New modern look and feel. 2. Enhanced master-detail management. 3. Custom templates. 4. Automatic Filter Row. 5. Filter Builder. 6. New visual themes. 7. Improved usability. 8. New Autocomplete and Milti-Level Autocomplete controls. 9. New "after action" events. 10. On-the-fly metadata refreshing. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/php_generators_updated_to_12_8/ Background information: ------- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Data Wizard 12.6 released
Hi! SQL Maestro Group announces the release of SQLite Data Wizard 12.6, a powerful Windows GUI solution for SQLite data management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/datawizard/ SQLite Data Wizard provides you with a number of easy-to-use wizards to convert any ADO-compatible database to the SQLite database, import data into SQLite tables, export data from tables, views and queries to most popular file formats as well as generate data-driven ASP.NET pages for your SQLite database. Top 10 new features = 1. The SQL Dump wizard. This tool allows you to export the data from selected tables and views as a set of INSERT statements. 2. Data Pump: User-defined data type mappings. 3. Data Pump: Recognizing autoincrement columns in the source database and converting them in the best possible way. 4. Data Pump: Data import using bulk-loading commands. 5. Data Import: Auto arranging target tables by dependencies. 6. Data Import: Import data from CSV files that contain multi-line strings. 7. Data Export: Decimal and thousand separators for the generated files (when applicable). 8. All tools: Correct exit status (0 on success, 1 on error) for the command-line mode. This return code can be checked in batch files using the ERRORLEVEL variable. 9. All tools: Progress windows are redesigned in the modern style and become more informative. 10. All tools: Log files become more structured and detailed. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release is available at: http://www.sqlmaestro.com/news/company/data_wizards_12_6_released/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: AnySQL Maestro 12.5
Hi! SQL Maestro Group announces the release of AnySQL Maestro 12.5, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (SQLite, PostgreSQL, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql/maestro/ AnySQL Maestro comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/anysql/maestro/free_vs_pro/ Top 10 new features: === 1. Report Designer. 2. Support for auto increment columns for MS SQL Server and MS Access. 3. SQL Editors: Unicode support, text change markers, and improved code folding appearance. 4. Enhanced performance of the SQL Script Editor tool. 5. Improved Script Runner. 6. Inline images in the data grid. 7. Displaying BLOB data as PDF. 8. Creation of views from Visual Query Builder. 9. Updated Data Input form. 10. Spanish translation. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/anysql_maestro_12_5_released/ Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQL Anywhere, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Code Factory 12.3 released
Hi! SQL Maestro Group announces the release of SQLite Code Factory 12.3, a powerful Windows GUI solution aimed at the SQLite queries and scripts development. The new version is immediately available for download at http://www.sqlmaestro.com/products/sqlite/codefactory/ Please also note that before March 18 you can get an additional 20% discount on purchasing any our product suite including recently launched Web Developer bundles. http://www.sqlmaestro.com/purchase/ Top 5 New features = 1. SQL Editor: unicode support, text change markers, code snippets, and improved code folding appearance. 2. Creation of views from Visual Query Builder. 3. Data import from any database accessible via ODBC driver / OLE DB provider. 4. Managing BLOB data as PDF. 5. Spanish translation. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release is available at: http://www.sqlmaestro.com/news/company/code_factory_advanced_to_12_3/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Data Sync 12.2 released
Hi! SQL Maestro Group announces the release of SQLite Data Sync 12.2, a powerful and easy-to-use tool for SQLite database contents comparison and synchronization. The new version is immediately available for download at http://www.sqlmaestro.com/products/sqlite/datasync/ Please note that before Feb 19 you can purchase SQLite Data Sync as well as all other our products and bundles with a 20% discount. Happy Valentine's Day! Top 5 new features: 1. Comparison and synchronization of the data represented by database views. 2. Automatic checking of table and column mappings. 3. Filters to compare and synchronize only subsets of data. 4. Exporting comparison results to Excel, HTML, XML, and more. 5. Auto sorting of the target tables to avoid potential integrity violations. Full press-release with explaining screenshots is available at: http://www.sqlmaestro.com/news/company/datasyncs_updated_to_12_2/ Background information: ------- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 12.1 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 12.1, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Top 10 new features = 1. SQL Editors: unicode support, text change markers, code snippets, and improved code folding appearance. 2. Backup Database tool. 3. New Encryption Manager. 4. Database Designer: highlighting foreign key columns. 5. Displaying BLOB data as PDF. 6. The "Execute at cursor" command for SQL Editor. 7. Table Editor: quick index creation. 8. Creation of views from Visual Query Builder. 9. Data Import Wizard: preserving options between sessions. 10. Spanish translation. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_12_1_released/ Background information: -------- SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 11.12 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 11.12, a powerful GUI frontend that allows you to generate feature-rich CRUD web applications for your SQLite database. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ SQLite PHP Generator comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/sqlite/phpgenerator/feature_matrix/ Please note that before Jan 15 you can purchase Professional Edition of SQLite PHP Generator as well as all other our products and bundles with a 20% discount. Happy New Year! Top 10 new features: 1. Security enhancements. 2. New PDF export engine with Unicode support. 3. New insertion and editing modes. 4. Advanced control management in Edit and Insert forms. 5. Improved project management. 6. Copying and viewing data in modal windows. 7. Lookup filtering. 8. Command line generator. 9. Speeded up schema refreshing. 10.Bug report sender. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/php_generator_updated_to_11_12/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Data Sync released
Hi! SQL Maestro Group starts a new product family and announces the release of SQLite Data Sync, a powerful and easy-to-use tool for SQLite database contents comparison and synchronization. http://www.sqlmaestro.com/products/sqlite/datasync/ Key product features: 1. Comparing and deploying changes to database contents. 2. Automatic creation of error-free synchronization scripts. 3. Easy-to-read difference display. 4. Saving all options to a project file for instant re-execution. 5. Custom comparison keys and flexible auto-mapping tools. 6. Full control over the comparison and synchronization. 7. Powerful command-line interface for continuous integration. Full press-release is available at: http://www.sqlmaestro.com/news/company/datasync_product_family_started/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SQLite Wiki doesn't work
Hi! The "Wiki" link at the SQLite home page displays a blank page: http://www.sqlite.org/cvstrac/wiki Regards, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: AnySQL Maestro 11.7 released
Hi! SQL Maestro Group announces the release of AnySQL Maestro 11.7, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (SQLite, PostgreSQL, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql/maestro/ AnySQL Maestro comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/anysql/maestro/free_vs_pro/ Please note that before the end of the month you can purchase a Professional edition of AnySQL Maestro as well as all other our products and bundles with a significant discount. Details are available at http://www.sqlmaestro.com/purchase/ Top 7 new features: === 1. Data pagination for the corresponding tab of object editors. 2. Code snippets for SQL Editor and SQL Script Editor. 3. Data import from any database accessible via ODBC driver / OLE DB provider. 4. Quick index creation. 5. The "Execute at cursor" command for SQL Editor. 6. Highlighting foreign key columns for Database Designer. 7. Default directories for data export/import/extract/etc. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/anysql_maestro_11_7_released/ Background information: ======== SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQL Anywhere, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 11.3 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 11.3, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ New features = 1. SQLite Maestro has been successfully tested with the newest SQLite versions. The latest available library (3.7.5) is now included into the installation package. 2. Support for SQLite full-text search extension modules has been implemented (both FTS3 and FTS4 are supported). 3. Now it's allowed to generate updatable views for your tables automatically. Moreover, the Insert, Update, and Delete operations can be enabled or disabled at your choice. It is possible to create such a view for a single table or for several tables at once (even for all the tables in the database). 4. Table Editor features an ability to upload files as BLOBs into a table. 5. Data Import: starting with this version it becomes possible to import data from any database accessible via an ODBC driver or OLE DB provider, such as SQL Server, MySQL, Oracle, MS Access, Sybase, DB2, PostgreSQL, etc. 6. Application Options: now it's possible to specify default directories for data export/import/extract/etc to be used on database profiles creating. 7. Some minor corrections and fixes. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_11_3_released/ Background information: -------- SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Data Wizard 11.1 released
Hi! SQL Maestro Group announces the release of SQLite Data Wizard 11.1, a powerful Windows GUI solution for SQLite data management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/datawizard/ SQLite Data Wizard provides you with a number of easy-to-use wizards to convert any ADO-compatible database to the SQLite database, import data into SQLite tables, export data from tables, views and queries to most popular file formats as well as generate data-driven ASP.NET pages for your SQLite database. New features = 1. Data Import: import from ODBC data sources has been implemented. This allows you to import data from any database accessible via an ODBC driver or OLE DB provider to SQLite. 2. Data Import: the Insert-or-Update mode has been added. 3. Data Import: now it is possible to specify SQL scripts to be executed before and/or after data import to each table. 4. Data Pump: starting with this version it is possible to define naming conventions for transferring metadata objects. 5. Data Pump: new version allows you to restrict number of pumped records, view source table data as well as count number of records in the source tables. 6. Data Export: when exporting to MS Access data from all the exported tables/views/queries are stored to a single target database. 7. Common: this release has been successfully tested with 64-bit operating systems including Windows 7 x64. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release is available at: http://www.sqlmaestro.com/news/company/data_wizards_are_updated_to_version_11_1/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 10.8 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 10.8, a GUI frontend that allows you to generate high-quality PHP scripts for the selected SQLite tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ SQLite PHP Generator comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/sqlite/phpgenerator/feature_matrix/ Please note that before September 5 you can purchase Professional Edition of PHP Generator as well as all other our products and bundles with a 20% discount. Top 10 new features = 1. Inline Insert and Inline Edit abilities. 2. Support for RSS feeds. 3. Environment variables (such as CURRENT_USER_ID) in events and templates. 4. Page-level permissions. 5. Client-side events including custom validators. 6. Easy access to recently used projects. 7. Changing number of records displayed at a page during app runtime. 8. Customizable menus. 9. Most-frequently used values for combo box editors. 10. Password encryption by the PHPass algorithm. Full press-release (with explaining screenshots and code samples) is available at: http://www.sqlmaestro.com/news/company/php_generators_updated_10_8/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: AnySQL Maestro 10.7 released
Hi! SQL Maestro Group announces the release of AnySQL Maestro 10.7, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (SQLite, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql/maestro/ This version features database profile management extensions, updated Script Runner, improved Data Analysis and Data Import tools, and some other useful things. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/anysql_maestro_10_7_released/ AnySQL Maestro comes in two editions: Freeware and Professional. The feature matrix can be found at http://www.sqlmaestro.com/products/anysql/maestro/free_vs_pro/ AnySQL Maestro 10.7 has been successfully tested with the SQLite ODBC driver by Christian Werner (http://www.ch-werner.de/sqliteodbc/) and all the latest SQLite versions. Background information: SQL Maestro Group offers complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQL Anywhere, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 10.5 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 10.5, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ New features = 1. This release has been successfully tested with all the latest SQLite versions as well as with 64-bit operating systems including Windows 7 x64. The latest available library (3.6.23) is now included into the installation package. 2. Support for native foreign keys has been added (SQLite 3.6.19 and higher). To enable/disable this feature, use the corresponding option within the Create Database Profiles or Edit Database Profile window. This option also affects the automatic creation of referential integrity triggers: they are NOT created if it is turned ON and vice versa. 3. Table Editor: a possibility of importing data from Clipboard has been implemented. It is supposed that columns within the data block are separated by the tabulation symbol, records are separated by newlines and the first line of the data block contains column headers. 4. The Update Existing Records option has been added to the Data Import wizard. If this option is turned ON, the records will be either updated or inserted. 5. Data Analysis tool features the following things: 5.1. Starting with this version it is possible to use a wide spectrum of aggregate functions such as maximum, minimum, average value, etc. for subtotals (the only available function for the previous versions was sum of values). 5.2. A possibility of sorting data by summary columns has been added. This means, for example, the product you'll see first is not the one which starts with an A or Z, but rather the one that has the most or least sales. 5.3. You can also specify the number of top rows that are displayed to view, for example, only a specific number of best-selling or worst-selling products for each year, month, customer, etc. This will help you to concentrate on only the most important information and avoid being overload with a lot of superfluous data. 6. The Script Runner window can now be invoked directly from the Tools menu. Also the productivity of this tool has been significantly improved. 7. Data Grid: the "Clone current record" command has been added to the popup menu. Use it to add a new record which is substantially similar to an existing one. 8. BLOB editor: starting with this version it is possible to select a BLOB column to edit directly within the editor window. 9. The "Case Insensitive" option has been added to data grid filter settings (ON by default). 10. Some other minor improvements and corrections. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/sqlite_maestro_10_5_released/ Background information: ------------ SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 10.3 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator 10.3, a GUI frontend that allows you to generate high-quality PHP scripts for the selected SQLite tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ Online demo: http://demo.sqlmaestro.com/ SQLite PHP Generator comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/sqlite/phpgenerator/feature_matrix/ Please note that before April 11 you can purchase Professional Edition of SQLite PHP Generator as well as all other our products and bundles with a 20% discount. Happy Easter! Top 10 new features: 1. Autocomplete and WYSIWYG editors. 2. Nested master-detail presentations. 3. Key columns for views and updatable queries. 4. Support for right-to-left languages (such as Arabic and Hebrew). 5. The read-only attribute for the column properties. 6. Project-level data manipulation events. 7. Default ordering for page records. 8. Updated image viewer and calendar components. 9. Filters to restrict number of records returned. 10. Data printing for single records. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/php_generators_advanced_to_version_10_3/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Code Factory 10.2 released
Hi! SQL Maestro Group announces the release of SQLite Code Factory 10.2, a powerful Windows GUI solution aimed at the SQL queries and scripts development. The new version is immediately available for download at http://www.sqlmaestro.com/products/sqlite/codefactory/download/ Please note that before February 14 you can purchase SQLite Code Factory as well as all other our products and bundles with a 20% discount. Happy Valentine's Day! New features = 1. Visual Query Builder has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs. 2. Data Export wizard has been significantly improved. Now you can export data to Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats and select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, Mac). Also the wizard has been completely redesigned to increase the usability. 3. Data Import wizard has been updated too. Now you can import data from Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats, import CSV and Text data files stored in different encodings, empty the target table as well as execute custom SQL scripts before and after import. This wizard also has been completely rewritten; moreover, the speed of the import process has been significantly increased. 4. Starting with this version it is possible to reorder servers in the Explorer Tree as well as reorder databases from the same server. You can also sort servers and databases in an alphabetical order. 5. Data grid: starting with this version it is possible to allow displaying row numbers in grids. Also we have added support for fixed columns. 6. Get SQL Dump: from now on you can specify output file encoding. 7. An Italian localization is now included into the installation package. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release is available at: http://www.sqlmaestro.com/news/company/code_factory_product_family_updated_to_version_10_2/ Background information: ------- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite PHP Generator 9.12 released
Hi! SQL Maestro Group announces the release of SQLite PHP Generator, a GUI frontend that allows you to generate a full set of PHP scripts for SQLite tables, views and queries for the further working with these objects through the web. http://www.sqlmaestro.com/products/sqlite/phpgenerator/ SQLite PHP Generator now supports both SQLite 2 and SQLite 3 databases. Online demo: http://demo.sqlmaestro.com/ Starting with this version SQLite PHP Generator comes in both Freeware and Professional editions. The feature matrix can be found at http://www.sqlmaestro.com/products/sqlite/phpgenerator/feature_matrix/ Please note that before December 31 you can purchase the Professional Edition of SQLite PHP Generator as well as all other our products and bundles with a 25% discount. Merry Christmas! Top 10 new features: 1. Support for updatable SQL queries. 2. Master-detail presentations. 3. Event-driven content management. 4. Client-side data validation. 5. Custom pagination (display partitioning). 6. Data export to PDF, XML, CVS, Excel and Word. 7. Support for hard-coded, table-based, and database server user authentication. 8. Record-level security. 9. Color schemes. 10. Multi-language support. Full press-release is available at: http://www.sqlmaestro.com/news/company/php_generator_family_updated_to_version_9_12/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Data Wizard 9.12 released
Hi! SQL Maestro Group announces the release of SQLite Data Wizard 9.12, a powerful Windows GUI solution for SQLite data management. SQLite Data Wizard provides you with a number of easy-to-use wizards to convert any ADO-compatible database to the SQLite database, import data into SQLite tables, export data from tables, views and queries to most popular file formats as well as generate data-driven ASP.NET pages for your SQLite database. The new version is immediately available for download at http://www.sqlmaestro.com/products/sqlite/datawizard/ New features = 1. Data Import: now you can import data from XML, Microsoft Office Excel 2007 and Microsoft Office Access 2007 file formats along with Microsoft Office Excel 97-2003, Microsoft Office Access, CSV, DBF, and Text files supported in the previous versions. Also starting with this version you can import Text and CSV data files stored in different encodings. 2. Data Import: now it is possible to empty target tables as well as execute custom SQL scripts before and after the import. 3. Data Import: the wizard has been completely redesigned to improve the look and feel and increase the usability. 4. Data Export: support for Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats has been implemented. Also now it is possible to select the result file encoding. This wizard also has been completely redesigned. 5. Datapump: the conversion rules for fields and indexes become more intelligent, so starting with this version most of source databases from well-known DBMS can be transferred even with default settings (or with a small customization). Also the speed of data transfer has been significantly increased. 6. An Italian localization is now included into the installation package. In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made. Full press-release is available at: http://www.sqlmaestro.com/news/company/data_wizard_family_updated_to_version_9_12/ Background information: --- SQL Maestro Group offers complete database admin, development and management tools for MySQL, SQL Server, PostgreSQL, Oracle, DB2, SQLite, SQL Anywhere, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?
> SQLiteSpy (www.yunqa.de) is OK, but unless I missed the option, it > won't let me copy the output of a SELECT into the clipboard so I can > paste it elsewhere. > > Are there better alternatives? SQLite Maestro allows you to copy query results to clipboard with ease: just execute a query and press Ctrl+A, Ctrl+C. It is also possible to export query results directly to MS Excel 97-2003, MS Excel 2007, CSV/DSV/TSV, HTML, XML, MS Access, PDF, DBF, RTF, OpenDocument Spreadsheet and some other formats. :-) http://www.sqlmaestro.com/products/sqlite/maestro/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: AnySQL Maestro 9.8 released
Hi! SQL Maestro Group announces the release of AnySQL Maestro 9.8, a powerful tool for managing any database engine accessible via ODBC driver or OLE DB provider (SQLite, MySQL, SQL Server, Oracle, Access, etc). The new version is immediately available at http://www.sqlmaestro.com/products/anysql/maestro/ This version features major improvements in Visual Query Builder, Data Export and Data Import tools, significantly updated Data Grid and a lot of other useful things. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/anysql_maestro_9_8_released/ AnySQL Maestro comes in two editions: Freeware and Professional. The feature matrix can be found at http://www.sqlmaestro.com/products/anysql/maestro/free_vs_pro/ AnySQL Maestro 9.8 has been successfully tested with the SQLite ODBC driver by Christian Werner (http://www.ch-werner.de/sqliteodbc/) and all the latest SQLite versions. Background information: SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQL Anywhere, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Importing data into SQLite
> I'm evaluating SQLite to be used as a small embedded database in a linux > environment for Skyfiber Inc. What is the best way to import data into it > ? I have a bunch of entities and attributes in an excel spreadsheet. Could > I import CSV ? What should be the columns (where can I read about this > etc) SQLite Maestro allows you to import data directly from Excel 97-2003, Excel 2007, Ms Access, CSV, TSV, DBF and XML files. :-) http://www.sqlmaestro.com/products/sqlite/maestro/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Forensics data control
>> Well, now we want to add some sophisticated forensics features. >> Currently we >> have fancy filtering but no real OLAP sort of capability. >> > Are you talking straight OLAP, or do you have other forensic needs > which will require you to roll your own functions ? The only mention > of OLAP on > > http://www.sqlite.org/cvstrac/wiki?p=ManagementTools > > is SQLite Maestro, a big many-functioned package compatible with many > SQL engines. Yes, SQLite Maestro includes an OLAP Builder. Examples can be found at http://www.sqlmaestro.com/products/sqlite/maestro/screenshots/getting_started/data_analysis/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] GUI design & managment tool?
>> Thank you for this message. We've just fixed the bug you mentioned and >> uploaded an updated version of SQLite Maestro at >> http://www.sqlmaestro.com/products/sqlite/maestro/download/ >> > Wow. Nice to see you folks monitoring this list. > >> > (Support for visual relation design would be great, too.) >> >> Yes, SQLite Maestro does include such a tool. >> http://www.sqlmaestro.com/products/sqlite/maestro/screenshots/getting_started/database_designer/ >> > I've been playing with the demo...Out of curiosity, is there any way > to have the connecting lines automatically route themselves around the > other shapes and automatically connect to the table next to the key they > represent? (Like MS Access, but perhaps less buggy...) To implement such an arrangement, it is necessary to implement a variation of a quite complex graph drawing algorithm; moreover some graphs cannot be drawn without edge crossings. Nevertheless we'll try to improve the "Apply best fit" feature within the next versions... ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] GUI design & managment tool?
Hi! > 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. Thank you for this message. We've just fixed the bug you mentioned and uploaded an updated version of SQLite Maestro at http://www.sqlmaestro.com/products/sqlite/maestro/download/ > (Support for visual relation design would be great, too.) Yes, SQLite Maestro does include such a tool. http://www.sqlmaestro.com/products/sqlite/maestro/screenshots/getting_started/database_designer/ ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 9.3 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 9.3, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ New features = 1. SQL Editor: support for explicit transaction management has been implemented. Now you can execute queries either in autocommit mode (default behavior) or manage transactions manually. In the second case you have to issue the BEGIN TRANSACTION statement to start a transaction and explicitly end the transaction by COMMIT or ROLLBACK statements (it is also possible to use the corresponding links at the editor's navigation bar). 2. Auto-attached databases become available for remote connections. 3. Starting with this version it is possible to create referential integrity triggers together with a foreign key creation. 4. Data Export wizard has been significantly improved. Now you can export data to Microsoft Office Excel 2007, Microsoft Office Word 2007, OpenDocument Spreadsheed, and OpenDocument Text file formats and select the result file encoding (ANSI, UTF8, UTF16, UTF32, OEM, Mac). Also the wizard has been completely redesigned to increase the usability. 5. Visual Query Builder has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs. 6. Trigger Editor: the Code Completion feature becomes available for the NEW and OLD keywords. 7. SQL Editor: starting with this version SQLite Maestro highlights the error line after executing an erroneous query. 8. An Italian localization is now included into the installation package. 9. Data grid: starting with this version it is possible to allow displaying row numbers in grids. 10. Tabbed MDI interface: a popup menu has been added to each tab. 11. Some other minor improvements and corrections. Full press-release (with explaining screenshots) is available at: http://www.sqlmaestro.com/news/company/5598/ Background information: ---- SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 8.11 released (database encryption support and other features)
Hi! SQL Maestro Group announces the release of SQLite Maestro 8.11, a complete Windows GUI solution for SQLite database management. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ What's new in this version === 1. Support for transparent database encryption has been implemented. It is possible to use SQLite Encryption Extension by Hwaci (if you have it) or a free wxSQLite3 library. 2. Remote database management has been significantly updated. Now you can connect to remote SQLite 3 databases as well as store the connection script in a password protected directory. 3. Starting with this version it is possible to use the lookup editor for a column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table's columns within the dropdown window. 4. A possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single master row). 5. Filtering, grouping, and sorting features become available for TEXT columns. 6. Data Import Wizard: now it is possible to truncate the table before importing. 7. Get SQL Dump Wizard and Extract Database Wizard have been redesigned to increase the usability. 8. Data Export, Data Import, and Get SQL Dump wizards now store their size and position. 9. Some other minor improvements and corrections. Full press release: http://www.sqlmaestro.com/news/company/5570/ Background information: -------- SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, DB2, Firebird, SQL Anywhere and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Data Wizard 8.4 released
Hi! SQL Maestro Group announces the release of SQLite Data Wizard 8.4, a powerful Windows GUI solution for SQLite data management. http://www.sqlmaestro.com/products/sqlite/datawizard/ SQLite Data Wizard provides you with a number of easy-to-use wizards to generate PHP and ASP.NET scripts for the selected tables, views and queries, convert any ADO-compatible database to the SQLite database, export data from SQLite tables, views and queries to most popular formats, and import data into the tables. New features = 1. Now it is possible to create a system scheduled task or convert a task created in Data wizard to system one. Such tasks can be executed by the Windows scheduler service even without user logon. 2. Command line options have been implemented. 3. Since this version each task is displayed as a separated icon in the system tray when executing. 4. A possibility of connecting to remote SQLite databases via HTTP tunneling has been implemented. 5. PHP Generator: a lot of new features. See full press-release for details. 6. Data Pump: now you can execute custom SQL scripts after connecting, before data importing and after pumping. 7. ASP.NET generator: since this version it is possible to specify a custom connection string. There are also some other useful things. Full press release is available at http://www.sqlmaestro.com/news/company/5148/ Background information: --- SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, DB2, PostgreSQL, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: AnySQL Maestro released (freeware cross-database tool)
SQL Maestro Group announces the release of AnySQL Maestro - a freeware, but powerful tool for all the database engines accessible via ODBC driver or OLE DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, SQLite, etc). http://www.sqlmaestro.com/products/anysql/maestro/ AnySQL Maestro has been successfully tested with SQLite ODBC driver by Christian Werner (http://www.ch-werner.de/sqliteodbc/), and all the latest SQLite server versions up to 3.5.6 Key features: - database object management - graphical database designer - visual query builder - data export and import - BLOB Viewer/Editor - and a lot of other things. Full press-release: http://www.sqlmaestro.com/news/company/4843/ Background information: SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, SQL Maestro Group http://www.sqlmaestro.com ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] ANN: SQLite Maestro 7.12 released
Hi! SQL Maestro Group announces the release of SQLite Maestro 7.12, a powerful Windows GUI solution for SQLite administration and database development. http://www.sqlmaestro.com/products/sqlite/maestro/ Please note that before December 31 you can purchase SQLite Maestro and our other products and bundles with a 25% discount. Merry Christmas! New features = 1. SQLite Maestro has been successfully tested with the latest SQLite server versions. The latest available server library (3.5.3) is now included into the installation package. 2. Support for attached databases has been implemented: now you can specify such databases in the Database Profile Editor to use their data in your SQL queries. 3. Reindex and Vacuum commands have been added for tables and indexes. 4. Graphical Database Designer - a case tool for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent tables in your SQLite databases. 5. Database explorer: now it is possible to group database profiles according to your needs. 6. The SQL Generator tool has been implemented. Use this feature to produce various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL Editor or SQL Script Editor. 7. Data Grid: the notification pane is now displayed after simple mode activation (filtering, grouping and sorting features are not supported in this mode). All the related settings can be customized in the Options dialog. 8. Data Grid: the Generate Query command has been added to the Table / View Editor. Use this command to copy current filter conditions to the SQL Editor window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid's popup menu. 9. Data Grid: now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu). 10. Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list. 11. Some other minor improvements and corrections. Full press release: http://www.sqlmaestro.com/news/company/4698/ Background information: -------- SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] ANN: SQLite Data Wizard 7.8 released
Hi! SQL Maestro Group announces the release of SQLite Data Wizard 7.8, a powerful Windows GUI solution for data management. SQLite Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. It allows you to generate PHP and ASP.NET scripts for tables, views and queries, convert any ADO-compatible database to the SQLite database, export data from SQLite tables, views and queries to most popular formats, and import data into the tables. http://www.sqlmaestro.com/products/sqlite/datawizard/ New version features: - ASP.NET Generator Wizard is implemented. - New Shell Application with Ribbon toolbars (like Office 2007) and more. - Unicode/UTF-8 support - PHP Generator: now it is possible to create a lookup menu for a column using a custom value list. - Data Pump: now optimized for Microsoft.Jet engine. - Data Import: the speed of loading of Excel files was increased. - All the wizards: a lot of minor improvements and corrections were made. Full press-release is available at: http://www.sqlmaestro.com/news/company/4457/ Background information: SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] ANN: SQLite Maestro 7.7 released
Hi All, SQL Maestro Group is announcing the release of SQLite Maestro 7.7, a powerful Windows GUI tool for SQLite databases administration and development. The new version is immediately available at: http://www.sqlmaestro.com/products/sqlite/maestro/ What's new in version 7.7? 1. The most important thing added in this version is support of Unicode/UTF-8 data. For databases in UTF-8 encoding it is necessary to specify, which string fields are used to store Unicode data (available options are "Only nvarchar(xx) fields" and "All the string fields"). For databases in UTF-16 encoding no such actions required. 2. Create database wizard: now it is possible to specify the encoding (UTF-8 or UTF-16) for the new database. 3. It is now possible to execute SQL scripts after connect and before disconnect to/from a database. 4. Some new features are incorporated into SQL Editor and SQL Script Editor. Now it is possible to comment/uncomment selected text, convert selected text to different cases, export the contents of the editor to RTF and HTML formats (to file or to clipboard), and print/preview the contents of the editor. 5. Some other new features. Full press release is available at: http://www.sqlmaestro.com/news/company/4435/ Background information: ======== SQL Maestro Group is engaged in developing complete database admin and management tools for MySQL, Oracle, MS SQL Server, PostgreSQL, SQLite, Firebird and MaxDB providing the highest performance, scalability and reliability to meet the requirements of today's database applications. Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] ANN: SQLite Maestro 7.3 released
Hi All, SQL Maestro Group is happy to announce the release of SQLite Maestro 7.3, a powerful Windows GUI tool for SQLite databases administration and development. The new version is immediately available at: http://www.sqlmaestro.com/products/sqlite/maestro/ The new version is mostly a maintenance release meant to add some interface features, increase stability and fix several non-critical bugs. Details are available at: http://www.sqlmaestro.com/news/company/3640/ Sincerely yours, SQL Maestro Group http://www.sqlmaestro.com - To unsubscribe, send email to [EMAIL PROTECTED] -
[sqlite] ANN: SQLite Maestro 6.12 released
Hi All, SQL Maestro Group is happy to announce the release of SQLite Maestro 6.12, a powerful Windows GUI tool for SQLite databases administration and development. The new version is immediately available at http://www.sqlmaestro.com/products/sqlite/maestro/ Also we're happy to grant you a time-limited 25% discount on all our products and bundles. Don't miss this unique chance to get our software at a special Christmas price! http://www.sqlmaestro.com/purchase/ What's new/changed in version 6.12? 1. The main feature of the new version is the tabbed MDI interface implementation (like Mozilla Firefox). Here are some its advantages: - you can drag-n-drop tabs to change their order; - you can close the current tab pressing the mouse wheel (or the middle mouse button); - you can drag-n-drop database objects or selected text between tabs; - each tab has a popup menu, which allows you to close current tab, close all tabs or close all the tab except selected one (close other tabs). 2. SQL Script Editor: if a user opens a file larger than 100K, SQLite Maestro will suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute script from file" link on the Script Editor navigation bar and specify the filename. 3. We've added an option for converting new object names to lower/upper case. 4. Data grid: the speed of data loading was significantly increased. 5. Some other improvements and small bugfixes. Sincerely yours, SQL Maestro Group http://www.sqlmaestro.com - To unsubscribe, send email to [EMAIL PROTECTED] -