Bablosoft

database customization

Locked Moved Support

  • loclan6879L

    How to make multiple computers work on the same BAS database???

    Support
    0 Votes
    4 Posts
    891 Views
    sergerdnS

    @loclan6879 said in How to make multiple computers work on the same BAS database???:

    @morpheus93 but my sql to dificult to use. i need db orginal of BAS. Can i???

    Using a database in any software is a common practice in development. I don't see any difficulties here.

    In any case, you don't have many options except to set up a database server on your local network, like MongoDB, MySQL, or something similar, and then connect your script to that database server.

    Another approach is to implement web app with an API for CRUD operations, such as Swagger, and create a simple BAS module to manipulate account data during registration or similar tasks. I use this method very often because it simplifies BAS coding, as all logic is implemented in the web app.

  • sanyaS

    Pls how do we export profiles to external database or server?

    Support
    0 Votes
    1 Posts
    371 Views
    No one has replied
  • G

    How to Remove Duplicate data from Database

    Support
    0 Votes
    1 Posts
    497 Views
    No one has replied
  • I

    Feature or a Bug? Two scripts using database simultaneously

    Support
    0 Votes
    5 Posts
    1142 Views
    I

    @Omini said in Feature or a Bug? Two scripts using database simultaneously:

    Transactions and Concurrency

    Great thanks, will do a bit more reading. I'm not sure what advanced DB settings BAS even has for this kind of thing. TBH I will probably just create a work around and start using a schedule to run with 1 thread regularly until a condition is met. Then the DB is updated in real time and massively minimises the odds of a single row being selected by two scripts. Bit of a pain, but I can't see any options in BAS so far to implement what you're discussing! Best Regards

  • M

    How to Avoid Duplicates in Database?

    Support
    1 Votes
    7 Posts
    2396 Views
    BAS Viet NamB

    There are many ways to handle this issue. I'll show you one way.

    For a news website, it's almost impossible for recently added articles to have 100% identical content. Therefore, you just need to compare the latest data added to your database with the data you're checking. If they are 100% identical, then the data has already been added, so you can skip it and check the next piece of data using the same process.

    So, for your request, you can convert the database to a list format, then retrieve the last element corresponding to the latest data added (or you can retrieve the latest data directly from the database if you know how to work with databases). Use Parse CSV string to parse the string into article title and content.

    You can compare the title of the latest article with the title you're checking. If they are 100% identical, then it has already been added to the database. If you want to be more certain, you can also compare the content (although this may not be necessary).

    I hope you understand what I'm saying.