Go to advanced search

by pfletch101
Mon Sep 03, 2018 8:59 pm
Forum: Other projects
Topic: Best way to store lap times data, and browse/sort data?
Replies: 2
Views: 583

Re: Best way to store lap times data, and browse/sort data?

You almost certainly want to store your data in a database, since that will most conveniently allow you to 'answer the questions' that you are interested in. If you want to store it on the Pi and access it from other places on the network, I would use MySQL or MariaDB (which work very similarly) as ...
by pfletch101
Mon Sep 03, 2018 12:31 am
Forum: Troubleshooting
Topic: I can't restore sd after bad noobs installing
Replies: 2
Views: 261

Re: I can't restore sd after bad noobs installing

It sounds as if the SD Card has gone read-only, which is a well known failure mode for these devices and should be regarded as a prelude to complete failure. If you have anything on it that you want and is not backed up you should copy it off asap, but otherwise the card is almost certainly useless.
by pfletch101
Sun Sep 02, 2018 9:36 pm
Forum: Français
Topic: Mail différé
Replies: 3
Views: 716

Re: Mail différé

Je veux vous aider, mais je ne connais q'un peu Francais. Il y a ici des 'forums d'autre langues' https://www.raspberrypi.org/forums/viewforum.php?f=65. Peut-etre on peut vous plus bien aidez la.
by pfletch101
Sun Sep 02, 2018 8:49 pm
Forum: C/C++
Topic: display time in microseconds on output of code
Replies: 6
Views: 1582

Re: display time in microseconds on output of code

My project involves using multiple MPU6050's to measure the dynamics of a motorcycle round a racetrack. To be able to do this i need to be able to measure at what time certain events happen. On an arduino, this can be accomplished using; time = millis() Or time = micros this is accurate to 4 micros...
by pfletch101
Sun Sep 02, 2018 6:40 pm
Forum: Python
Topic: import MySQLdb
Replies: 5
Views: 501

Re: import MySQLdb

Are you sure you need to use MySQLdb.connection() instead of MySQLdb.connect(). I wondered that, too, and I haven't used MySQL from Python, but Googling around suggests that either can be used, with .connect() being more common. I couldn't quickly determine what (if any) difference there was betwee...
by pfletch101
Sun Sep 02, 2018 3:44 pm
Forum: Python
Topic: import MySQLdb
Replies: 5
Views: 501

Re: import MySQLdb

This has annoyed me for days now, I don't understand what TypeError: is asking me to do. ======================== RESTART: /home/pi/DBtest.py ======================== Traceback (most recent call last): File "/home/pi/DBtest.py", line 7, in <module> db = MySQLdb.connection(LocalHost,User,ip,Password...
by pfletch101
Sat Sep 01, 2018 3:44 pm
Forum: Beginners
Topic: start app via ssh
Replies: 11
Views: 1299

Re: start app via ssh

A relatively easy way of implementing what you are trying to do while just using your SFTP connection would be to have the Pi program running all the time but Sleeping unless/until a specific file appears in a specific location. To 'start' it, you create the file; to 'stop' it, you delete the file.
by pfletch101
Fri Aug 31, 2018 10:41 pm
Forum: Python
Topic: Sql servet with rpi
Replies: 7
Views: 651

Re: Sql servet with rpi

You have 10 road techs with iPhone then the 1 pc in parts room... the road techs when going out to a customer can use iPhone app to add customers info and there equipment information to the database easily. The pc in the shops room will use that information to order parts with and to store common p...
by pfletch101
Fri Aug 31, 2018 9:35 pm
Forum: Python
Topic: Sql servet with rpi
Replies: 7
Views: 651

Re: Sql servet with rpi

What you propose doing is perfectly possible, but you will need to take care to maintain the security of your Pi DB server when it is exposed on the internet. You will need to install a database manager on the Pi - MySQL or MariaDB should work very well for this - and load your existing data into Ta...
by pfletch101
Fri Aug 31, 2018 12:51 am
Forum: Networking and servers
Topic: client side static IP or DHCP server side reserved IP for Raspberry?
Replies: 11
Views: 3403

Re: client side static IP or DHCP server side reserved IP for Raspberry?

I vote for letting the router do its job of managing the network and telling it if you want certain devices to be assigned to specific IP addresses. In addition to the reasons cited here and elsewhere by myself and others, one of the bigger considerations for me is that using the router's address ta...
by pfletch101
Thu Aug 30, 2018 10:24 pm
Forum: Beginners
Topic: Build your own weather station project
Replies: 17
Views: 2161

Re: Build your own weather station project

For most purposes, MariaDB and MySQL should look and behave the same 'from the outside', since the former is essentially a development branch of the latter. I would expect almost all code that works for a MySQL database to work without change for an identically designed and structured MariaDB databa...
by pfletch101
Thu Aug 30, 2018 8:57 pm
Forum: Troubleshooting
Topic: Why do I have an dynamic (DHCP) IP address if setting a static IP address on Raspian Lite Stretch?
Replies: 11
Views: 4162

Re: Why do I have an dynamic (DHCP) IP address if setting a static IP address on Raspian Lite Stretch?

If you want to have your Pi at a known, fixed, IP address, which is an entirely reasonable thing to want, the right way to do this is to have the router always assign it the same address (based on its MAC address). I wouldn't say it's 'the right way to do it' as if an absolute and it doesn't seem t...
by pfletch101
Thu Aug 30, 2018 6:56 pm
Forum: Troubleshooting
Topic: Why do I have an dynamic (DHCP) IP address if setting a static IP address on Raspian Lite Stretch?
Replies: 11
Views: 4162

Re: Why do I have an dynamic (DHCP) IP address if setting a static IP address on Raspian Lite Stretch?

I and others have repeatedly said this before, but it is almost never necessary (and usually a bad idea) to set a fixed IP address for a Pi (or any other WiFi client) at the client level on a normal, DHCP-managed, WiFi network. There are just too many ways that things can go wrong if you do this. If...
by pfletch101
Wed Aug 29, 2018 12:22 pm
Forum: Raspberry Pi OS
Topic: Rebooting raspberry pi 3 issues
Replies: 8
Views: 1257

Re: Rebooting raspberry pi 3 issues

Probably the most useful thing to do next is to load a clean version of Raspbian (or the OS you are using, if different) onto a new SD card and confirm that this boots and runs normally. Without a backup (lesson learned, I hope!?), you will then have to recreate your setup, step by step, testing and...
by pfletch101
Tue Aug 28, 2018 8:48 pm
Forum: Automation, sensing and robotics
Topic: Temp/humidity sensor (DHT22) causing false positives in PIR sensor
Replies: 11
Views: 1438

Re: Temp/humidity sensor (DHT22) causing false positives in PIR sensor

I am working from first principles and from previous (many years previous!) experience of data acquisition hardware running on DEC minicomputers, so I may be way off base. Nevertheless, I wonder if the apparent interaction between the TH sensor chip and the PIR sensor arises outside the Pi. How is p...
by pfletch101
Tue Aug 28, 2018 3:02 pm
Forum: Advanced users
Topic: Compare two images then convert the new image into text
Replies: 18
Views: 1952

Re: Compare two images then convert the new image into text

After a thorough research, i may be doing OCR on the taken image picture because the image taken will have words or specifically like for example scrabble words i will convert it into text then get the words on what's written on the Scrabble board. I don't know of any OCR applications that can deal...
by pfletch101
Mon Aug 27, 2018 7:48 pm
Forum: Raspberry Pi OS
Topic: Rebooting raspberry pi 3 issues
Replies: 8
Views: 1257

Re: Rebooting raspberry pi 3 issues

No-one will be able to help you without more information!

Is this the first use of a new Pi? Is this something that just happened to a Pi that previously turned on without problems? Have you recently changed anything (software or hardware) in your setup?
by pfletch101
Mon Aug 27, 2018 7:35 pm
Forum: Advanced users
Topic: Compare two images then convert the new image into text
Replies: 18
Views: 1952

Re: Compare two images then convert the new image into text

Hi, I am doing a project based on image processing and I am in need of comparing 2 images taken from a pi camera then convert the new image into text. Can any suggest in any way on how to do it, I'm still a beginner and wanted to make if this is possible. In comparing two images, I mean I wanted to...
by pfletch101
Mon Aug 27, 2018 7:21 pm
Forum: Beginners
Topic: Is it safe to use a pc ATX power supply?
Replies: 25
Views: 5035

Re: Is it safe to use a pc ATX power supply?

Incidentally a 3A fuse will last for a minute at 6A, possibly a lot longer. So you must choose your fuse to blow before permanent damage occurs to downstream (or, for that matter, upstream) wiring. Were you consciously exaggerating how long an overloaded fuse will last, for effect? Other than fuses...
by pfletch101
Sun Aug 19, 2018 3:52 pm
Forum: Advanced users
Topic: My SQL on pi 3 b+?
Replies: 10
Views: 5310

Re: My SQL on pi 3 b+?

Is My SQL or MariaDB a web based system? MySQL/MariaDB servers (I link them because the latter can be thought of as a somewhat enhanced version of the former, and their broad functionalities can be considered as equivalent in most applications) run as services on their host systems. They are typica...
by pfletch101
Sun Aug 19, 2018 3:03 pm
Forum: Automation, sensing and robotics
Topic: An offline motion-capture security camera?
Replies: 6
Views: 1914

Re: An offline motion-capture security camera?

What you describe is perfectly feasible - indeed, it would be slightly simpler than making the images available over a network - but it is far from clear how useful it will be. In order to view the images you have captured (indeed, even just to know that you have captured any!) you will have either ...
by pfletch101
Sun Aug 19, 2018 2:44 pm
Forum: Advanced users
Topic: My SQL on pi 3 b+?
Replies: 10
Views: 5310

Re: My SQL on pi 3 b+?

I have several Access 2010 databases that I would like to be able to use when I am using Ubuntu 18.04 on my PC. The PC is multiple boot with Ubuntu 18.04, Windows 7, and Windows 10. The problem is that Access 2010 will not run in Ubuntu (with Wine). Other MS Office 2010 programs do, but not Access....
by pfletch101
Thu Jul 19, 2018 3:53 pm
Forum: General programming discussion
Topic: Computer Fan Sensor Wire
Replies: 1
Views: 1064

Re: Computer Fan Sensor Wire

There are two issues. The fan sensor wire probably outputs two 12V pulses for every rotation of the fan, and you certainly do need to condition that to something that can safely be fed to a GPIO pin - a resistor voltage divider circuit should work for that, though I might be inclined to add an appro...
by pfletch101
Sat Jul 14, 2018 11:50 pm
Forum: Beginners
Topic: How to restore rewritten version of CSV file?
Replies: 11
Views: 1286

Re: How to restore rewritten version of CSV file?

On an ext4 file system retrieval of deleted files even with the file name is possible due to file system journal. The recovery result depends on the time the file system remains in operation after file deletion. So, if you've done much more data writing, your chances decrease with time and usage. G...
by pfletch101
Sat Jul 14, 2018 10:49 pm
Forum: Beginners
Topic: How to restore rewritten version of CSV file?
Replies: 11
Views: 1286

Re: How to restore rewritten version of CSV file?

I'm new to Raspberry Pi world and Python 3. I have written some program for logging data from sensors of my RPi. The data is being written to a CSV file but with 'w' which means that the previous version of the file deletes and the file is being rewritten every next time. Today I wrote my data to t...

Go to advanced search