March 2015 Developer's Poll

Use this forum for polls.

Does your application use a database?

a. Yes
35
78%
b. No
10
22%
 
Total votes : 45

March 2015 Developer's Poll

Postby Damon » Thu Apr 02, 2015 11:13 pm

My application stores data in a flat text file because the data needs aren't quite demanding enough to warrant a database. However, I now need online updates and retrieval, so I will need to switch to using a database.

How about everyone else? How do you deal with your application's data needs?

Thanks in advance for your votes!

Cheers,
Damon Chandler
Editor-in-Chief
C++Builder Developer's Journal
http://bcbjournal.com
User avatar
Damon
BCBJ Editor and Admin
BCBJ Editor and Admin
 
Posts: 285
Joined: Wed May 26, 2004 11:25 pm
Location: Stillwater, OK, USA

Re: March 2015 Developer's Poll

Postby smd » Fri Apr 03, 2015 3:16 pm

I am playing with Firedac and a couple other techniques for using a database in my programs. So far SQLite seems the best route. Simply download from http://sqlite.org/download.html the amalgamated C file and add it to your program. Usually compiles without any adjustments. For most general uses, four function calls are all you need to do most everything. Works by simply passing SQL statements. Still have not yet figured out a reason why I would use Firedac, DBExpress, Interbase instead of SQLite.
-----------------------------
Scott
smd
BCBJ Guru
BCBJ Guru
 
Posts: 130
Joined: Sat Nov 29, 2014 8:02 pm
Location: Las Vegas

Re: March 2015 Developer's Poll

Postby macicogna » Fri Apr 03, 2015 6:48 pm

Hi,

I have some experience with Firebird, since its version 1.0. Actually, I've started using Interbase 5 and I must say that all my learning curve was valid and respected until now.

One nice feature of Firebird is its Embedded version. With a few files you can create a Portable version of you App. So, this might be a option to you when thinking about to migrate your flat file data structure.

This Portable case was successful for me using Firebird Embedded. It was incredible not to change one line of code to see my regular client/server app running in one pendrive. First with BDE, that took some Registry work to permit the portability, and now with ZeosLib, that makes everything easy as it needs just some BPL files to be put together with the your executable.

Talking about migrating systems with flat database files, I think SQLite is a nice option too and if you try ZeosLib, you can use it and even change the DBMS later.

As you can see, I'm a ZeosLib fan.

Best,

Marcelo.
User avatar
macicogna
BCBJ Veteran
BCBJ Veteran
 
Posts: 68
Joined: Mon Aug 04, 2008 4:57 pm
Location: Brazil

Re: March 2015 Developer's Poll

Postby smd » Fri Apr 03, 2015 9:14 pm

Marcelo,

I went to the sourceforge page for Zeoslib, but it is just the forum for it, could not find a download link. Could you post a link to its download page. I want to play around with it and see how it works.
-----------------------------
Scott
smd
BCBJ Guru
BCBJ Guru
 
Posts: 130
Joined: Sat Nov 29, 2014 8:02 pm
Location: Las Vegas

Re: March 2015 Developer's Poll

Postby macicogna » Sat Apr 04, 2015 9:06 am

Hi smb,

You can find it in SourceForge at:

http://sourceforge.net/projects/zeoslib ... =directory

Also, there is a thread that I've participated that they mentioned the latest version from SVN repository ( ZEOS 7.2 Revision 3609):

http://zeoslib.sourceforge.net/viewtopi ... 38&t=21225

And you can find the packages for C++Builder that I've been working with:

viewtopic.php?f=10&t=2597
(Associated with the BCB Journal's Vol 19, N.2 article)

If you need any help, please let me know.

Best,

Marcelo.
User avatar
macicogna
BCBJ Veteran
BCBJ Veteran
 
Posts: 68
Joined: Mon Aug 04, 2008 4:57 pm
Location: Brazil

Re: March 2015 Developer's Poll

Postby rlebeau » Sun Apr 05, 2015 4:13 pm

My company uses IBObjects to access FireBird (we migrated from InterBase, and never rewrote to use native FireBird clients yet), and DbExpress to access MS SQLServer.
Remy Lebeau (TeamB)
Lebeau Software
User avatar
rlebeau
BCBJ Author
BCBJ Author
 
Posts: 1544
Joined: Wed Jun 01, 2005 3:21 am
Location: California, USA

Re: March 2015 Developer's Poll

Postby Lena » Mon Apr 13, 2015 8:20 am

I use FireDAC+PostgreSQL.
Lena
BCBJ Master
BCBJ Master
 
Posts: 583
Joined: Sun Feb 06, 2011 1:28 pm

Re: March 2015 Developer's Poll

Postby sollmann » Sat Apr 25, 2015 8:26 pm

I too use SQLite. Very easy to use in my applications. Started using for custom button names and commands. Will soon start saving GPS tracking data. The only issue is where to store the database where corporate IT allows read/write access.
sollmann
 
Posts: 3
Joined: Tue Mar 19, 2013 9:05 pm
Location: McKinney, TX

Re: March 2015 Developer's Poll

Postby 2ffat » Thu Apr 30, 2015 4:43 am

I used MS SQL and Firebird. I'm curious, has anyone has tried MongoBD or NoSQL yet?
James P. Cottingham

Look at me still talking
when there is science to do.
User avatar
2ffat
Forum Mod
Forum Mod
 
Posts: 433
Joined: Wed Jun 23, 2004 7:07 am
Location: South Hill, VA

Re: March 2015 Developer's Poll

Postby macicogna » Tue May 05, 2015 9:57 am

Hi Damon,

What about an article showing how to build Portable applications using the Firebird Embedded version?

Also, if you share the structure of your flat file data (just a general idea), a can provide a quick tutorial to migrate it to a SQL structure.

Please let me know if this idea sounds good to the BCB Journal's community.

Best,

Marcelo.

P.S. I'll copy this post to the Proposals forum.
User avatar
macicogna
BCBJ Veteran
BCBJ Veteran
 
Posts: 68
Joined: Mon Aug 04, 2008 4:57 pm
Location: Brazil


Return to Polls

Who is online

Users browsing this forum: No registered users and 3 guests