I hope Frans will reconsider and add it with the next version or the one after that.

You could opt for SqlServer CE Desktop as well. v2.5 supports SqlServer CE Desktop.

I'm still hoping that VistaDB drivers may getting added in some near future version. A db written in fully managed code that runs that runs under the CF and Mono and can be used across a network is a good investment for us; would love to use LLBLGen with it.

Vikram

BeauGeek wrote:

I'm still hoping that VistaDB drivers may getting added in some near future version. A db written in fully managed code that runs that runs under the CF and Mono and can be used across a network is a good investment for us; would love to use LLBLGen with it.

Vikram

So does SqlLite, it's not written in a .net language though.

We'll be making changes to the website to allow more downloads to appear also on the public site. We have supported customers to write 3rd party drivers in the past (for Foxpro and informix for example) and we're planning to offer them as downloads (they're now in subversion only). If someone wants to write a vistadb driver/dqe, no problem, but we're not planning to write one ourselves.

Frans,

If there was a LLBLGen driver for SqlLite, I'd try it in a minute.

As for writing a driver for VistaDB -- I downloaded the custom drivers and read through the threads about making drivers. I'm afraid constructing a driver would be beyond my skillz, which are on the amateur side rather than leet.

So it seems for the moment I'm confined to SQL CE, which is rather a pain in the behind, what with its plethora of DLLs and having to first construct the database on a SQL 2500 server, lack of stored procedures, etc.

Vikram

You could opt for firebird embedded, which uses the same .fdb file as on the server, so no missing features.

I'm totally agree with Frans.

After SQL 2005 Firebird is the best choice for midsized businesses. Both editions (Server and Embedded)

Full Featured Good Prefomance Good behavior in .NET (Due to a good .NET Data Provider (FirebirdClient). Thanks to Carlos Guzman Alvarez) Excellent behavior with LLBLGen You can implement your own Concurrency control paradigm. Easy Deploy Easy installation Free Maintenance Good tools for admin Easy migration from SQL Server (http://sqlmanager.net/en/products/ibfb/datapump) Version 2.1 and 3.0 in the Roadmap It's absolutely free

This Database deserves our attention.

I'm using it in a production environment with excellent results.

Regards Gianfranco

Hello Frans & LLBLGen Team...

Thank you for your thought leadership. Excellent product here.

Current Project Needs Multi-user, file-based database support is required for my current project.

Current LLBLGen Drivers Firebird Embedded looks to be single-user only. SQLce doesn't support network share. (Is Jet/Access really a wise option?)

SQLite Driver I would be pleased to see an SQLite Driver! 2 Questions:

• Relationships - Would entity relationships be preserved? (SQLite doesn't support Foreign Keys)
• Roadmap - Is an SQLite Driver in the LLBLGen Roadmap? Looking forward to your response. Thanks again -

Ryan D. Hatch

rdhatch wrote:

Hello Frans & LLBLGen Team... Thank you for your thought leadership. Excellent product here.

Current Project Needs Multi-user, file-based database support is required for my current project.

File based database support with multiple users is tricky. MS Access has such a feature, it's reasonable fast up till 20 users or so if I recall correctly. After that it's seriously bad performing.

File based databases, or embedded databases, are almost always single user, simply because if you want multi-user database access, you need a service to manage locking, transactions etc. and multi-user access to data (so multi-staging of the data, per connection).

so I'd seriously consider a database system with a service for this instead of a file based system.

Current LLBLGen Drivers Firebird Embedded looks to be single-user only. SQLce doesn't support network share. (Is Jet/Access really a wise option?)

SQLite Driver I would be pleased to see an SQLite Driver! 2 Questions:

• Relationships - Would entity relationships be preserved? (SQLite doesn't support Foreign Keys)
• Roadmap - Is an SQLite Driver in the LLBLGen Roadmap? Looking forward to your response. Thanks again -

Ryan D. Hatch

SQLite isn't on our roadmap, as no databases are currently on our roadmap. If FK constraints aren't supported (like Mysql with their own db format), you can always create the relations in the designer and they're obviously preserved after a refresh, unless fields are removed which are the base of a relation of course

Hello rdhatch,

I have had a very bad experience using MsAccess over a network (10 users / 40 tables / an average of 100 records per table, 150'000 for the biggest one ). It was very slow because it generated too much network traffic, even for simple queries...

On the other side, sqlite is known to be very fast but doesn't support FK constraints and doesn't understand many DDL statements (LIKE DROP COLUMN).

stefcl -

Appreciate your input. This is precisely why I would like an SQLite driver for LLBLGen:

• Relationships would need to be defined in LLBLGen Pro's interface.
• DDL Drop Column could be implemented in the LLBLGen driver by creating a temp table, copying data over, dropping table, and recreating the table without the column - all within a Transaction. Any thoughts on SQLite Driver? Frans?

Ryan

Frans wrote:

SQLite isn't on our roadmap, as no databases are currently on our roadmap.

As far as I know, nothing has changed for the above statmenet.

Walaa wrote:

Frans wrote:

SQLite isn't on our roadmap, as no databases are currently on our roadmap.

As far as I know, nothing has changed for the above statmenet.

Exactly.

If someone wants to write a 3rd party DQE/driver, go ahead, but we're not planning to extend the set of databases at this point