Conversation

Notices

1. Embed this notice
   Sir Nedwood (ned@noauthority.social)'s status on Monday, 11-Nov-2024 12:50:00 JST Sir Nedwood

   Hey fedi ppl. I have a need at work to create an online database and some basic processing on the data. The aim is to import and export CSVs of various formats, and drawing data from multiple tables. Can someone point me in the right direction for doing something like this.

   • Embed this notice
     ?? Humpleupagus ?? (humpleupagus@eveningzoo.club)'s status on Monday, 11-Nov-2024 12:49:59 JST ?? Humpleupagus ??

     in reply to
     Sqlite
   • Embed this notice
     penguin (penguin@eveningzoo.club)'s status on Monday, 11-Nov-2024 12:51:07 JST penguin

     in reply to

     • ?? Humpleupagus ??
     sqlFatFuck
   • Embed this notice
     ?? Humpleupagus ?? (humpleupagus@eveningzoo.club)'s status on Monday, 11-Nov-2024 12:51:43 JST ?? Humpleupagus ??

     in reply to

     • penguin
     Did you trademark your brain? 😏
   • Embed this notice
     penguin (penguin@eveningzoo.club)'s status on Monday, 11-Nov-2024 12:51:58 JST penguin

     in reply to

     • ?? Humpleupagus ??
     😏 sqlsexy
   • Embed this notice
     ?? Humpleupagus ?? (humpleupagus@eveningzoo.club)'s status on Monday, 11-Nov-2024 12:57:20 JST ?? Humpleupagus ??

     in reply to

     • penguin
     Sqlite is sometimes better for small databases. I keep my time in it. The table is simple, so no need for an extensive database. I dump the to csv and import it into QB for billing.
     
     Also, if it needs to be online and if access is personal, gemini (which is kinda like a modern gopher server) can be easy to set up and use. About 5 lines in a config is all that's needed to get it up. I actually use gemini as a front end for my local gutenberg project files. It can search the index and open specific texts.