Skip to content
View in the app

A better way to browse. Learn more.

Power Forum - Renewable Energy Discussion

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Database locked error

Featured Replies

Will add the Infini's later !!

  • Replies 56
  • Views 14.1k
  • Created
  • Last Reply

Top Posters In This Topic

Most Popular Posts

  • Okay. Let's cut the technical BS here. In plain words, i'm a mechanic. You can use technical terms like motor technician, engineer, anything but i will stay a mechanic. Although i'm able to do some mo

  • SilverNodashi
    SilverNodashi

    I actually did hesitate about that statement, but know I would have been flamed for saying "shouldn't ICC be run as a Service instead?" .... Imagine that confusion!

  • incagarcilaso
    incagarcilaso

2 minutes ago, Manie said:

Thanks Chris for the compliment. Yes i do have a job work from 7 to 16H00 and do programing after hours.

All very true what you say. I always forget that there are programmers out here and are know there stuff. I am trying to see what the user wants, not me myself bu the user.

I did not even include the Infini yet as I have one. I did the windows one , started with the Axperts as a lot do have one. 

Very true, i still have apps going with access by a mine that is getting data from a PLC !!

 

 Yes this is what i am trying to do and hope to do one day

 

I am a strong believer of " positive thinking "

Would like to rephrase your last sentence to: "and will do soon ! "

10 hours ago, Chris-R said:

I am a strong believer of " positive thinking "

It's brain chemistry. When you think positively, the brain makes juices that makes you feel good. That stuff is so powerful it can change sugar pills into medicine and sell itself in pharmacies... (yes, I'm taking a poke at homoeopathics :-) ).

  • Author
14 hours ago, Manie said:

Yes I totaly agree with you.

Sent from my SM-G920F using Tapatalk
 

Postgre works well with Tomcat as an "unattended" DB back end and could be a viable alternative, although everything for pi I see is currently on Apache. Which DB does the Windows version use? If occasional DB maintenance by users is necessary then the way to do this might be through a web-based front-end. It should be fairly simple to do (famous last words) if the tasks are few and straightforward.

As far as the "locked error" from multiple sessions is concerned, I'm sure there must be a way to get round that in MySQL, MSSQL or Postgre but I'm not sure how at the moment.

Choice of technology stack to use is always so difficult but I generally allow the factors "open source" and "interoperability" to sway me heavily, especially for projects of the nature of ICC.

  • Author
11 hours ago, Chris-R said:

The forum members are very different to the normal man in the street, and I agree with Czauto - You need a potent, simple and easy to use system, for the masses.

The way I understand ICC, I fully agree with this concept for development - I see it as totally what is needed. @Czauto is probably not the only one who has given up on getting a pi up and running, unfortunately, although he is one of the few who has mentioned it. Not a criticism at all, ICC on pi is more than great but it may not be the right system for the person who can only do "plug and play". That is actually quite convenient because as a rule of thumb users who are looking for the simplest plug and play apps are generally Windows users. The Windows ICC should do this for them.

I sometimes think it is a myth that windows is more "user friendly". The fact is that people almost unknowingly train themselves on the system they work with most, and that retraining is a very expensive exercise (in mental terms). After that, everything else becomes difficult.

But that is the lay of the land. I fear that very soon I'll have to re-allow Windows into the house, because that's what the school will mandate for the kids. I'm not quite sure who's going to pay for the license though... cause it ain't me :-) I have like 4 different unused licenses of various versions of windows that came with laptops that were never used (wiped before they were booted once), I think I've paid my dues.

Aaaanyway, it is true. If you want to help the average user, it's got to be a windows thing that click-click installs.

On 2/7/2017 at 2:56 PM, Manie said:

I would have gone MySQL / MariaDB / PostgreSQL

A database is a database, and i agree that there is not one size fits all, but if you code better in one that an other, or know it better, then i would suggest the use of that one over any other, as if you truly know a database you know its caveats, and you can say what you like about any database, but if you want to get technical about it then you need to consider the actual flash medium that you are using to store that database on as well, the cache level of these writes, the data loss on unexpected power loss, I have built systems on firebird that has run for 15 years without maintenance, yet, each day, they make their backup to an external.

My point is 2 Dimensional, All Databases are Flat files that you use scripts to access, the better the scripts the better this goes (indexes, pre - loads, views) and so forth are all fantastic, if you know the database structure/software/code, and boils down to the fact, did you save R150 on you TFT drive, Did you add an R50 USB flash Drive with your database backups?

 

So when you say a Database is crap, are you referring to  the fastest database with the highest chance for corruption, or the one that like in this instance only allows single access for safety, lower odds for for corruption?

 

 

 

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.