Bablosoft

database customization

Locked Moved Support

  • loclan6879L

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

    Support
    0 Votes
    4 Posts
    757 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.

  • hellomembershaH

    Database restart where left off

    Support
    0 Votes
    4 Posts
    543 Views
    FoxF

    @hellomembersha said in Database restart where left off:

    @Fox If I want to filter database for any lines NOT matching a specific date in one of the columns how would I do that? It would be a reverse filter basically.

    In the standard database module, the "not equal" condition exists only for the "int" data type, which means you can write a date in milliseconds to a column with this data type and then use a filter with the "not equal" condition

  • Y

    Database forgots often which group to post to

    Support
    0 Votes
    1 Posts
    690 Views
    No one has replied
  • Y

    How to connect to remote database?

    Support
    0 Votes
    1 Posts
    1170 Views
    No one has replied
  • M

    How to Avoid Duplicates in Database?

    Support
    1 Votes
    7 Posts
    2257 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.