5 ms·

Just integrated littlefs into my stm32 framework. Author has a helper library for coroutines, which can be used to plug in asynchronous hooks, making the fs no

by Inviz 5y ago

Just integrated littlefs into my stm32 framework. Author has a helper library for coroutines, which can be used to plug in asynchronous hooks, making the fs non-blocking. My next step is to run SQLite on it.

hungryforcodes 5y ago
SQLite on an STM32
- chme 5y ago
  STM32 is a very broad range of chips. STM32MP1 runs Linux and I am sure SQLite as well ;) And even leaving the MP1 aside, the STM32H7 micro controller has a ARM Cortex-M7 core which runs up to 550MHz.
  - qbasic_forever 5y ago
    Just wild to me that a 'little' microcontroller for a few bucks is more powerful than any computer I had up to about 1998 or so.
    - kevin_thibedeau 5y ago
      Take solace that your phone would have been a TOP500 supercomputer in the early 90s.
    - winrid 5y ago
      Hurts even more when you were using a 450mhz PIII in 2006...
      - exikyut 5y ago
        HA, same here!! IBM 300PL by any chance? Mine (256MB, 8GB) ran Windows 98, and (record scratch) a copy of Visual Basic 1.0 that I'd stumbled on an abandonware copy of while attempting to figure the internet out at the local library. lol Then there was the the 486 with 4MB RAM and 8MB free disk that I was playing with just a year earlier (yep - 2005). And the 800MHz AMD Duron w/ 320MB RAM I used between 2012-2014. And now there's a 2004-era Pentium 4 in the corner here that I'm currently running ddrescue on to try and shoo away ~300KB of unhappy disk sectors. What can I say... work-blocking health issues guarantees life will be InTeReStInG haha Still playing catchup to equilibrium, and taking longer than I'd like because where it matters I annoyingly go a little slower than everyone else (huff). I'm almost certain you were probably doing something slightly more interesting on your PIII...? Delphi, maybe, or perhaps a newer (interestinger) version of VB? Or maybe a super-lightweight Linux setup and Vim? (Oh now that reminds me of the old Toshiba laptop I found on the side of the road with a ~300MHz K6-2 and (IIRC) 32MB RAM in it... hibernation worked so well on that thing it's how I would typically boot into Slackware on it (4 second resume time on a 20 year old laptop?!?! yes please!). Sadly my install CD was a bit scratched so the only things that really worked were bash, grep and sed... which I attempted to write a package manager for Slackware in. I got halfway there too, but had to quit because the 15-line regexes I was writing were giving me a headache. However, to this day I have zero issue with regular expressions up to sed's level of complexity. I do badly need to go back and revisit the subject though.)
        winrid 5y ago
        Hi! It was just some old no name PC gifted to me with an intel mobo and 128mb of ram. Ran Win98, but I soon discovered Ubuntu 6.10 which ran fine on it. I got free ram upgrades and used it to play free games (tons of time in Wolf ET) and learn programming. Tried a bunch of OSes after that. Eventually I got a free 1ghz PIII and mobo which was a nice upgrade that lasted until late 2007 when I built a Core2Duo machine. Hope you get well soon.
        exikyut 5y ago
        Woops, apologies I lost this tab mid-reply :( Very cool. I only knew about Knoppix at that point, which being a LiveCD didn't quite like 128MB RAM (just realized that's how much RAM my PIII had too, huh). Properly switched to Linux (cold-turkey :D) around 2007, and my focus on programming took a giant nosedive as I discovered the internet. Upgraded from Pentiums/Celerons to an i3 a friend gave me in 2012 IIRC. Still figuring out how to juggle the internet and focusing on programming lol I'm not "sick" per se, it's really just the whole head-exploding dumpster fire that is government support around mental health and "I really cannot jump this curb *points* so what do I do now?" et al. It's just a matter of time, fingers crossed things get figured out before I'm like 35 or 40... hmph
    - HeyLaughingBoy 5y ago
      I remember pointing out to someone that they could run ISA-bus peripherals on an AVR-Mega processor. Not that there would be much point, but it would be cool to take a board from an original IBM PC and run it from a $2 microcontroller.
      - deleted 5y ago
        [deleted]
    - Narishma 5y ago
      They may be fast but they are still stuck with extremely small amounts of memory.
  - Inviz 5y ago
    Even STM32F4 which is sub-10$ can run SQLite decently. 4kb ram for stack is quite enough, and then whatever amount of working memory you can afford on it will make life easier. Using sram extension makes it trivial even.
- stemawayyejr 5y ago
  Difficult but doable. You'd have to shim some syscalls and kludge the build into an embedded toolchain, but there's no technical reason why it can't work.
  - monocasa 5y ago
    It's actually not that bad; SQLite has a very abstracted vfs layer that is pretty trivial to port to arbitrary platforms.
    - pantalaimon 5y ago
      There is also FlashDB which is more lightweight and can operate directly on flash
    - Inviz 5y ago
      Yes, it only needs like 4 or 5 VFS hooks to be defined. No syscall malarkey

by Inviz 5y ago

hungryforcodes 5y ago

SQLite on an STM32

chme 5y ago
STM32 is a very broad range of chips. STM32MP1 runs Linux and I am sure SQLite as well ;) And even leaving the MP1 aside, the STM32H7 micro controller has a ARM Cortex-M7 core which runs up to 550MHz.
- qbasic_forever 5y ago
  Just wild to me that a 'little' microcontroller for a few bucks is more powerful than any computer I had up to about 1998 or so.
  - kevin_thibedeau 5y ago
    Take solace that your phone would have been a TOP500 supercomputer in the early 90s.
  - winrid 5y ago
    Hurts even more when you were using a 450mhz PIII in 2006...
    - exikyut 5y ago
      HA, same here!! IBM 300PL by any chance? Mine (256MB, 8GB) ran Windows 98, and (record scratch) a copy of Visual Basic 1.0 that I'd stumbled on an abandonware copy of while attempting to figure the internet out at the local library. lol Then there was the the 486 with 4MB RAM and 8MB free disk that I was playing with just a year earlier (yep - 2005). And the 800MHz AMD Duron w/ 320MB RAM I used between 2012-2014. And now there's a 2004-era Pentium 4 in the corner here that I'm currently running ddrescue on to try and shoo away ~300KB of unhappy disk sectors. What can I say... work-blocking health issues guarantees life will be InTeReStInG haha Still playing catchup to equilibrium, and taking longer than I'd like because where it matters I annoyingly go a little slower than everyone else (huff). I'm almost certain you were probably doing something slightly more interesting on your PIII...? Delphi, maybe, or perhaps a newer (interestinger) version of VB? Or maybe a super-lightweight Linux setup and Vim? (Oh now that reminds me of the old Toshiba laptop I found on the side of the road with a ~300MHz K6-2 and (IIRC) 32MB RAM in it... hibernation worked so well on that thing it's how I would typically boot into Slackware on it (4 second resume time on a 20 year old laptop?!?! yes please!). Sadly my install CD was a bit scratched so the only things that really worked were bash, grep and sed... which I attempted to write a package manager for Slackware in. I got halfway there too, but had to quit because the 15-line regexes I was writing were giving me a headache. However, to this day I have zero issue with regular expressions up to sed's level of complexity. I do badly need to go back and revisit the subject though.)
      - winrid 5y ago
        Hi! It was just some old no name PC gifted to me with an intel mobo and 128mb of ram. Ran Win98, but I soon discovered Ubuntu 6.10 which ran fine on it. I got free ram upgrades and used it to play free games (tons of time in Wolf ET) and learn programming. Tried a bunch of OSes after that. Eventually I got a free 1ghz PIII and mobo which was a nice upgrade that lasted until late 2007 when I built a Core2Duo machine. Hope you get well soon.
        exikyut 5y ago
        Woops, apologies I lost this tab mid-reply :( Very cool. I only knew about Knoppix at that point, which being a LiveCD didn't quite like 128MB RAM (just realized that's how much RAM my PIII had too, huh). Properly switched to Linux (cold-turkey :D) around 2007, and my focus on programming took a giant nosedive as I discovered the internet. Upgraded from Pentiums/Celerons to an i3 a friend gave me in 2012 IIRC. Still figuring out how to juggle the internet and focusing on programming lol I'm not "sick" per se, it's really just the whole head-exploding dumpster fire that is government support around mental health and "I really cannot jump this curb *points* so what do I do now?" et al. It's just a matter of time, fingers crossed things get figured out before I'm like 35 or 40... hmph
  - HeyLaughingBoy 5y ago
    I remember pointing out to someone that they could run ISA-bus peripherals on an AVR-Mega processor. Not that there would be much point, but it would be cool to take a board from an original IBM PC and run it from a $2 microcontroller.
    - deleted 5y ago
      [deleted]
  - Narishma 5y ago
    They may be fast but they are still stuck with extremely small amounts of memory.
- Inviz 5y ago
  Even STM32F4 which is sub-10$ can run SQLite decently. 4kb ram for stack is quite enough, and then whatever amount of working memory you can afford on it will make life easier. Using sram extension makes it trivial even.
stemawayyejr 5y ago
Difficult but doable. You'd have to shim some syscalls and kludge the build into an embedded toolchain, but there's no technical reason why it can't work.
- monocasa 5y ago
  It's actually not that bad; SQLite has a very abstracted vfs layer that is pretty trivial to port to arbitrary platforms.
  - pantalaimon 5y ago
    There is also FlashDB which is more lightweight and can operate directly on flash
  - Inviz 5y ago
    Yes, it only needs like 4 or 5 VFS hooks to be defined. No syscall malarkey