sgNeoDatabase: VisualNEO Win Business Application Stack - Forum

Forum Navigation
You need to log in to create posts and topics.

sgNeoDatabase: VisualNEO Win Business Application Stack

Presenting the sgNeoDatabase Plugin for developing advanced applications integrating SQLLite,MySQL,MariaDB and PostgreSQL. The plugin has the following eatures:

  • sgNeoDatabase is a comprehensive database plugin designed for VisualNEO/NeoBook applications.
  • It provides a unified interface for SQLite, PostgreSQL, MySQL, and MariaDB databases.
  • It supports queries, transactions, prepared statements, asynchronous operations, and database management.
  • Its integrated DataGrid capabilities enable interactive viewing and editing of database records.
  • Built-in Chart, PDF, and print features support reporting and professional data presentation.
  • Security functions include encryption, hashing, HMAC, Base64, and secure token generation.
  • Schema-inspection tools simplify the exploration and visualization of database structures.
  • Integration with email, forms, and reporting enables complete business and information-management applications.
  • Its importance lies in bringing modern database functionality to VisualNEO without requiring complex external programming.
  • sgNeoDatabase transforms VisualNEO into a powerful platform for developing secure, data-driven professional applications.

The uploaded zip file contains the plugin, required DLL files, an exhaustive help file, and a demo pub file. Please report any runtime, crash, freezing VisualNeo Win IDE, or other relevant issues for rectification. The plugin is free to use, and the source code will be uploaded soon.

The plugin can be downloaded from: https://saptarshi.in/neoplugins/sgNeoDatabase.zip

 

luishp, Vadim and 6 other users have reacted to this post.
luishpVadimluizalangonzalez91danitoraslAnthony LaTorreiretz

Is this still available? Can't download

It works. paste this in your browser.  whole thing.

https://saptarshi.in/neoplugins/sgNeoDatabase.zip

impactband4u has reacted to this post.
impactband4u

This is greatly appreciated.  I do have a question.  Is there a way to have VisualGrids and objects?

I guess my question is....is there a way to tell ChatGPT to make Visual Modern Plugins?  Upon using  VN WIn.  I dont like having to draw a box and not be able to see what the layout is as I'm making it and guess.  If I can't do this then this is not a tool I will be using going forward.  I knnow this has been the way i the past to make plugins, but Luis spoiled us and showed it can be done the other way.

ALso, I was going to buy the new Modern Plug in extensions to support this, but I have not seen anything that tells me that they are visual Plugins?  I am assuming all Modern Plugins are "Visual" but can you let me know if they are.  NO way to test them yet.

Thanks

@no1g8tor96 Yes, all modern plugins now have visual interfaces! That's one of the major improvements.
I'm currently working on the second iteration of the plugin framework, along with an SDK designed to make AI-assisted plugin development much easier.
This next version will also support custom panels and allow users to try commercial plugins before purchasing them.
Regards.

Vadim and luiz have reacted to this post.
Vadimluiz

Thanks Luis.  Have some ideas for plugins but need them visual. Can’t wait for the SDK. Great stuff.

 

luishp has reacted to this post.
luishp

@no1g8tor96

Till now we have complete Plugin SDK help file and examples up to Delphi 10. @Luis introduced a fresh approach to develop 'VisualNeo Win' plugins. I am not making plugins with that model, nor do I know the architecture of such plugins as they are directly included into the Toolbox of VisualNeo Win. I have been using Delphi 10 source code and the Plugin SDK provided on the VisualNeo Website. Using AI and my little knowledge in Object Pascal(help me debug), I made these plugins. Visual means drag and drop? If so I am also waiting for the SDK or whatever form @Luis. That interface is helpful. However, I am curious about non- VCL( Visual Component Library) controls and how to render them from the Toolbox. Probably, we need to wait for the modern SDK.

I have updated the sgNeoDatabase with more commands and a design-time action that makes control on-the-fly as in "NeoDB Pro: so that MySQL, PostgreSQL, SQL Lite can be opened and be placed into the VisualNeo Win page without manual effort. Please have a try. Due to file size upload restriction, providing here the plugin and the demo. Other dependent library files are available here: https://saptarshi.in/essentials.zip

Uploaded files:
luishp, Vadim and 2 other users have reacted to this post.
luishpVadimluizdanito

@sghoshnbu

Hi : ) I installed the sgNeoDatabase but now when I open up VisualNeo is freezes the program when loading the plugins. I restart my PC but it keeps freezing when I start VN. Any idea why?

Thank you.

 

You need to download essentials.zip mentioned in many previous post. Download the file and extract all into the directory where  neodatabase.nbp is extracted. These files are dependencies for running the database plugin working. Check it and revert. I will load the full zip in my site today.

Full plugin with all required dependencies. Download here: https://saptarshi.in/sgNeoDatabasefull.zip

Vadim has reacted to this post.
Vadim

@impactband4u

Thank you for your reply.  I think what your making is amazing and I’m working with it now to see what it’s does.  Very impressive.

I am a newer purchaser of VisualNeo products and came from environments where you drag n drop and see real time what your making. For me dropping in a blank square and then have to spend much time making the item look right is not good in my time.  There are too many other products I don’t have to do this with.  Luis understand this and seems to be moving this way as well.   His new plugins are great and sold me on this now to look more into programming with it.

For me and a few other programmers who have looked at this with me, seems the better product is VN Web.  If it were more visual drag n drop would make more sense since it can be deployed to different platforms and not just Windows.  But inuderstand that this Windows product has been around the longest so I guess Luis is trying to keep it alive with this upgrades.  But I don’t see this as a path to bring in many new users. Mac, phones, websites are more viable to new users.    I use another product and it can do so much more than this and can compile into EXE, DMG, HTML etc and the cost is under $100 for the complete package. But I really like the ease of this platform and Like the personal attention of the forum.

I told Luis a few weeks ago, I made a program for a Fortune 500 company with VNWeb and they are using it in one department and hopefully soon more.

Here is the thing. They are 99.9 percent Windows based but with the lockdown of computers on Domains you can’t just send an EXE file and have then install. To get around it I made it into and HTML program and it just runs in a browser.  No exe or windows picking it up as a potential threat.

if I was locked into a Windows only environment I would have lost the work. So this is important to many.

anyways thank you all for the support and keep innovating as it’s the only way to keep this alive.

Hi @sghoshnbu

I am trying your app but at start or some button action, I crash with this command.

~VNU8:

 

 

sghoshnbu has reacted to this post.
sghoshnbu

@Phil78

Thank you for reporting the issue. Will fix those tomorrow. Specifically SQL, Transaction and async page buttons have issues. Have a nice day.

joferar333 has reacted to this post.
joferar333

Hello, @sghoshnbu

I have reviewed the sgNeoDatabase plugin documentation for VisualNEO Win, and I would like to ask you a technical question.

Does sgNeoDatabase support Microsoft Access databases (.mdb and .accdb)?

If these formats are not directly supported, is it possible to connect to them using ODBC or another method?

I currently have several applications developed in VisualNEO Win that use Microsoft Access MDB databases through NeoDBPro.

I would like to know if I can use sgNeoDatabase with my existing MDB files without having to migrate them to SQLite.

If this is possible, could you please provide an example of the connection command?

Thank you for your time and assistance.

Best regards.

luiz has reacted to this post.
luiz

@joferar333

Added MS Access(both MSB and Accdb)support.

Please download: https://saptarshi.in/sgNeoDatabase_With_Access.zip

Please keep all DLL files and the nbp file in a single folder and install the plugin. A demo pub is uploaded as well.

Please

Uploaded files:
  • daaccess1.png
  • daaccess2.png
  • daaccess3.png
Vadim, alangonzalez91 and 2 other users have reacted to this post.
Vadimalangonzalez91impactband4udanito

Hi, is there a report designer for creating print layouts?

@sinesi-giuseppee

Yes. The plugin now has a built-in report designer. Please check the demo and report pages. A report file, data.nrf, is included in the demo directory.

The plugin requires dependent dynamic libraries for MySQL, PostgreSQL, and MariaDB. However, MS Access files can be used directly if the Microsoft ODBC driver is already installed on the machine.

The modified plugin is available here:
https://saptarshi.in/sgNeoDatabase.zip

If you require the DLLs, download them here:
https://saptarshi.in/help_dll.zip

For deployment, all DLL files and the NBP file must be in the same directory. When distributing the plugin, it is essential to bundle the DLLs with the executable.

 

Uploaded files:
  • report_designer.png
  • preview.png
  • run_time.png
Vadim, dglojnar and 4 other users have reacted to this post.
Vadimdglojnarluizalangonzalez91impactband4uSinesi Giuseppe

Great work @sghoshnbu .

Updated the Database Plugin with a remote connection example.

Download the updated plugin from: https://saptarshi.in/sgNeoDatabase.zip

The included demo file is a fictitious Hospital Management Database. Try it.

Uploaded files:
  • remote_database1.png
  • remote_database2.png
  • remote_database3.png
Anthony LaTorre has reacted to this post.
Anthony LaTorre