Black Falcon Software Releases SQLite Helper 4.5

SQLite

The SQLite database is probably the leading embedded database engine in the entire Information Technology industry. Small, fast, and relatively straightforward to use it has attracted a very wide following of devotees, developers, and vendors that take advantage of its excellent quality and versatility.

Used in all types of embedded systems from operating systems to the desktop, SQLite is the database engine of choice for those requiring a solid database for their applications.

However, support within the .NET developer community has been somewhat of an ambiguous proposition since SQLite, being a C\C++ database engine primarily, has not had the necessary support for ADO.NET beyond several open-source projects managed by individual developers.

The two leading projects in this venue have been the PHXSoftware and Finisar implementations but both of these offerings have since been discontinued.

DevArt Software has recently begun offering an excellent and freely available product for such purposes to the .NET developer community and Black Falcon Software did consider its use for it’s “SQLite Helper” product. However, it was thought a better idea to use the most direct offering from the SQLite Foundation itself if at all possible.

Luckily for the .NET community, the SQLite Foundation has adopted the original PHXSoftware project as its own and is now maintaining it on a regular basis. However, this does not appear to be widely known from the research done.

All such products for SQLite combine the SQLite database assembly with an ADO.NET provider, which then allows any .NET language to access it in similar style.

Black Falcon Software is now proud to release its first SQLite Data Access Layer, SQLite Helper 4.5, that takes advantage of the SQLite Foundation’s .NET offering.

Like all of the Black Falcon Software data access layers, SQLite Helper 4.5 follows the same standardized format for offering all of the primary functions for data access processes. SQLite Helper 4.5 also offers a streamlined approach to processing transactions allowing the developer to choose between setting up a transaction whereby only single point of action and thus failure can be processed or spreading the processing of a transaction over as many method calls as may be necessary.

This updated approach to transactions follows the new approach taken with the SQL Helper 4.5 component for SQL Server databases, which was released this past July.

SQLite Helper 4.5 is a complete package, which offers the developer the following tools…

  • SQLite Helper 4.5 Data Access Component (with complete source code and existing access to the referenced SQLite database assembly)
  • SQLite Helper 4.5 Test Client (with complete source code)
  • A complete set of documentation for SQLite Helper 4.5 in a HELP file
  • The complete implementation of the “System.Data.SQLite” component from the SQLite Foundation
  • NET, an excellent general database manager, which is freely available for non-commercial use. Database.Net can be used against a variety of databases in addition to SQLite.

The SQLite Helper 4.5 source code comes in a solution that is compiled for the .NET 4.5 Framework. However, it can be easily recompiled for any of the frameworks, 4.5 or higher.

This new set of tools from Black Falcon Software is sure to make it easier and more convenient for .NET developers to implement SQLite processing within their applications without the additional complexities of using an ORM.

Give SQLite Helper 4.5 a try today. It can be freely downloaded from the following link…

http://www.blackfalconsoftware.com/Software

If you have any comments, suggestions, or questions regarding this new software, please send all notes to support@blackfalconsoftware.com

 

A Publication of Black Falcon Software

BFS_splash-screen-purple-sun_140x105

2010: The Deconstruction…

2010 - The Deconstruction

Initial notes…

The following piece is a sociological analysis of the state of professional software development today. As one who is not just a senior software engineer but a military historian\analyst as well, I have brought together the skills of both these areas of expertise to demonstrate to the technical community at large that what is happening to our profession has nothing to do with innovation or new opportunities in application development but instead is an ongoing process of terrible, deleterious, degradation that has professionals everywhere concentrating on abstract concepts, useless paradigms, and redundantly, new tool introductions without any analysis as to the benefit of their application to the development of new applications. In fact, little has been reported on the success (or failure) of application development itself, as this aspect of reporting has been pushed aside for the less relevant aspects of our profession. Is it not the final product that is important and not what makes it?

The negative results of this process are staggering and are not simply the result of a software profession overwhelmed by marketing hype and vendor misdirection both supported by an avalanche of “me too” groups of young professionals trying to insert their own ideas but is as much also a symptom of what is happening to societies in general.

To understand that this deterioration is not isolated to our profession alone, one should take a look at the article at Russia Insider at

http://russia-insider.com/en/military/epic-fail-heres-why-most-us-weapons-systems-are-worse-russias/ri11097. The article is written by a US military analyst and provides some in-depth details as to the state of the US Armed Forces and intelligence agencies. You will also find some of my own historical notes in the comments section below it.

To add to this, one may also want to see John Oliver’s piece on the state of US nuclear arsenals, which is both hilarious and terrifying at the same time (https://www.youtube.com/watch?v=1Y1ya-yF35g). Much of what Oliver reports has already been reported in the mainstream news outlets.

Cognizant functionality in life today is quickly deteriorating in all areas of industrialized societies into nothing but a cacophony of gibberish and nonsense, not to mention the terrible social and political traumas being afflicted on citizens across the globe along with horrific conflicts and their affects. The software development profession has not been immune to these trends…

Read more of this post

Using Black Falcon Software’s SQL Server Source Control for Developers

SSSC_UsingBlackFalconSoftware's_SSSCProduct

Overview

Application source control is a veritable standard in all well-run Information Technology organizations.   However, it is surprising how many small organizations seem to believe that individual developers merely saving backups of their projects on a remote server is more than enough for source control processes.

It is even more surprising how many quality IT organizations that do not have formal database teams ignore database source control thinking that the backed-up databases housing the scripts are more than enough for such a vital development process.

To some degree the lack of such control on databases is understandable given that there are few products available for organizations to avail themselves of. In fact, the only substantial products available are for Microsoft’s SQL Server database, while many other database engines are involved in production processes throughout the international IT community.

For Microsoft’s SQL Server, both ApexSQL and Red-Gate offer excellent products for teams and as a result, are rather expensive for individual professionals to afford. However, Black Falcon Software now offers a far more affordable solution for professionals looking to incorporate database source control into their development processes that will allow them to avoid the pitfalls of having their database scripts deleted or modified by others accidentally while under development when source control is not available.

Such a situation can be a traumatic situation when one has developed quite a number of new tables, procedures, or other such objects in a test database only to have them suddenly disappear as a result of a colleague’s work on the same database. And this is a common occurrence since test databases in many instances tend to be regarded as reusable by those working with them.

To begin with, Black Falcon Software’s SQL Server Source Control for Developers is not designed for teams but instead for the individual professional who wants and\or needs to maintain ongoing versions of all the database object scripts that they are developing without the more elaborate requirements of a remote source control systems such as TFS or Subversion. Stored in local repositories on the desktop, developers can now implement easy-to-use database source control for SQL Server that are protected from accidental modifications by colleagues or worse, complete database refreshes when it is felt that such a refresh is required. Under either condition, recreating original scripts can be a taxing experience.

Black Falcon Software’s product has a very simple set of administrative source control processes.

Starting with the administration of the application, the developer is presented with the following options…

*** click on the images to enlarge them

Read more of this post

%d bloggers like this: