Skip Navigation
InitialsDiceBearhttps://github.com/dicebear/dicebearhttps://creativecommons.org/publicdomain/zero/1.0/„Initials” (https://github.com/dicebear/dicebear) by „DiceBear”, licensed under „CC0 1.0” (https://creativecommons.org/publicdomain/zero/1.0/)CE
Ceedling @compuverse.uk
Posts 9
Comments 24
Self-Hosting @compuverse.uk Ceedling @compuverse.uk

Help generating reports from db's

compuverse.uk Help finding the right software. - CompuVerse

I keep running my head into a wall working on a project and I am hoping you guys can help me. I have created a database that contains the addresses of contacts. What I need to accomplish is generating paper reports of these addresses. So, for example, I may have 25 addresses on one report related by...

0

Needing help generating reports from db's

2

Help finding the right software.

I keep running my head into a wall working on a project and I am hoping you guys can help me. I have created a database that contains the addresses of contacts. What I need to accomplish is generating paper reports of these addresses. So, for example, I may have 25 addresses on one report related by some other data point. I figured that I should easily be able to pull info from my database and fill a PDF template with it that I could then print out, but this has proven harder than expected.

So far, I've tried airtable and notion (I know, but I was temporarily having server issues and I need to get this project done) I've also tried baserow and nocodb, and yet I can't seem to figure out how to generate printable reports from my data.

Does anyone else know of an option? I've seen a recommendation for creating a spreadsheet or word document as a template that you then copy/paste your data into, but that feels... inelegant? Would something like appsmith or budibase be capable of this? Or is there some other (preferably self-hosted) software to accomplish this? I appreciate any help you can give me.

Edit: Sorry everyone, I guess I didn't make it very clear. First off, I've been using the programs above to make my dB's. So for instance, my nocodb is set up to use mysql. I didn't generate the dB on my own, and admittedly, I've never interacted with a db directly using SQL markup before.I was hoping my goal could be accomplished with a low/no-code option as my coding skills are rudimentary right now.

As someone asked, for a printable-report, yes PDF is an option. As would a word document or spreadsheet, for that matter, just so long as I can get it into a nice, print-friendly format.

I do appreciate all the suggestions so far, and will look into them. Thanks!

12

Thoughts on ExtremeRate shells?

Sorry if this has already been asked. I tried to do a search, but it's a bit harder to figure out how to focus the search on Lemmy. Anyway, I want to buy one of these shells as a present for my wife, but I want to make sure they're worth it. Does anyone have any personal experience with them? I haven't been able to find much in the way of reviews on them so far. Thanks!

12
Is there any feedback of the current blackout? Feels like everything will be over soon and it's going on like before.
  • My question is- why not start moving some of that content to Lemmy? If users who have contributed value to reddit replicated that content over to Lemmy, it seems like that would be fertilizer to the soil. I know it's not reasonable to expect it to be done all at once, but if the few thousands just chipped away at moving even some of their best picks over the next few months, I think that would help with the growth on Lemmy. (Unfortunately, my contributions would be more akin to manure...)

  • if you see someone wearing camo, do you automatically assume they're a prepper?
  • Not really. Where I'm from, camo is popular with a few different groups (hunters, farmboys, and some urbanites) but none of them seem much into prepping from any of my knowledge. (Not that individuals in those groups don't, but it's not a general pattern that any of those groups do prep)

  • What is everyone's opinion on jmp.chat?

    As I continue to look for new tools to increase my data/identity protection, I came across jmp.chat as an interesting phone service. It seems like a potentially nice way to privatize phone and SMS more, but I'm a novice at all of this and wonder if anyone else has done more research on this matter. Does anyone have opinions on this service?

    9
    How is "Grounded" on steam deck?
  • I love it! My wife and I play it all the time. We were having a hard time with Xbox login on the deck, but once you get past that annoyance, its great. I'm fine with the graphics (yes, I notice some abberations) but I'm not one who makes a major fuss about that. Game content is way more important to me than graphics. But, it's not that the graphics are bad, I just think that those who are really sensitive to this might be frustrated. It will kill your battery, though! I basically just play with my steamdeck plugged in.

  • Preppers/survival @lemmy.ca Ceedling @compuverse.uk

    Good beginner food preservation techniques?

    My wife and I are getting more and more into prepping, and one area I really want to break into is food preservation. We have a garden going, and I know we're going to have more than we can eat, so I'd like to save some over. However, whenever I start doing research into canning, it becomes very complicated very quickly, and a little overwhelming. What are some good ways to get some practical food preservation accomplished for the uninitiated? Currently, I'm looking at fermentation as a good way to preserve some of our vegetables, but without canning them, they are only safe in the fridge. I do know that it varies somewhat depending on the specific foods, so maybe include details like that a well.

    3
    Help getting started
  • Are you very familiar with xmpp or jmp.chat? Would I gain any benefit in using jmp.chat by having my own xmpp server? With my own xmpp server, I own my account, but I don't know if I can then connect that in any meaningful way to jmp.

  • Help getting started

    cross-posted from: https://compuverse.uk/post/5020

    > Preamble- I'm new to the fediverse, and I want some help. I'm trying to regain some of my privacy and data sovereignty, and I have recently gotten into self-hosting. I haven't been on social media for over a decade, except for Reddit, and that was mostly as a passive lurker. I just started getting more active on there this past year, and now they've turned me away with their shenanigans. I'm trying to get into federated communications to still have access to useful information while protecting my identity and data. > > Goals- I'm thinking that I want to set up my own Lemmy instance, as well as my own xmpp server (like prosody), and switch over to jmp.chat. I also have my own domain. > > Concerns- I want to spin up my own services so that I own my data and have greater control over my connections, and possibly have a hub that friends and family can use. However, I also don't want to expose my domain (Why not? I don't know. I'm completely new at this and until I learn more, I'm playing it cautious) > > Questions- So, if I spin up my own Lemmy instance, doesn't that expose my domain,since my username will be [email protected]? Is this the same for an xmpp server? One main reason to spin up my own xmpp server is to own my account for xmpp communications. However, can I tie that to my jmp.chat account, or would they need to be separate. > > I kind of feel like a boat without an oar at the moment, and I'm not even sure if I'm asking sensical questions, but hopefully there's enough light in my ramblings to give you all a sense of my goals. Any help would be appreciated.

    11
    Self-Hosting @compuverse.uk Ceedling @compuverse.uk

    Help getting started

    cross-posted from: https://compuverse.uk/post/5020

    > Preamble- I'm new to the fediverse, and I want some help. I'm trying to regain some of my privacy and data sovereignty, and I have recently gotten into self-hosting. I haven't been on social media for over a decade, except for Reddit, and that was mostly as a passive lurker. I just started getting more active on there this past year, and now they've turned me away with their shenanigans. I'm trying to get into federated communications to still have access to useful information while protecting my identity and data. > > Goals- I'm thinking that I want to set up my own Lemmy instance, as well as my own xmpp server (like prosody), and switch over to jmp.chat. I also have my own domain. > > Concerns- I want to spin up my own services so that I own my data and have greater control over my connections, and possibly have a hub that friends and family can use. However, I also don't want to expose my domain (Why not? I don't know. I'm completely new at this and until I learn more, I'm playing it cautious) > > Questions- So, if I spin up my own Lemmy instance, doesn't that expose my domain,since my username will be [email protected]? Is this the same for an xmpp server? One main reason to spin up my own xmpp server is to own my account for xmpp communications. However, can I tie that to my jmp.chat account, or would they need to be separate. > > I kind of feel like a boat without an oar at the moment, and I'm not even sure if I'm asking sensical questions, but hopefully there's enough light in my ramblings to give you all a sense of my goals. Any help would be appreciated.

    1

    Help getting started

    Preamble- I'm new to the fediverse, and I want some help. I'm trying to regain some of my privacy and data sovereignty, and I have recently gotten into self-hosting. I haven't been on social media for over a decade, except for Reddit, and that was mostly as a passive lurker. I just started getting more active on there this past year, and now they've turned me away with their shenanigans. I'm trying to get into federated communications to still have access to useful information while protecting my identity and data.

    Goals- I'm thinking that I want to set up my own Lemmy instance, as well as my own xmpp server (like prosody), and switch over to jmp.chat. I also have my own domain.

    Concerns- I want to spin up my own services so that I own my data and have greater control over my connections, and possibly have a hub that friends and family can use. However, I also don't want to expose my domain (Why not? I don't know. I'm completely new at this and until I learn more, I'm playing it cautious)

    Questions- So, if I spin up my own Lemmy instance, doesn't that expose my domain,since my username will be [email protected]? Is this the same for an xmpp server? One main reason to spin up my own xmpp server is to own my account for xmpp communications. However, can I tie that to my jmp.chat account, or would they need to be separate.

    I kind of feel like a boat without an oar at the moment, and I'm not even sure if I'm asking sensical questions, but hopefully there's enough light in my ramblings to give you all a sense of my goals. Any help would be appreciated.

    Edit— for those wondering why I don't want to expose my domain: As an example, many people will post their personal information on social media. They think ‘why not? What harm can it do when I talk about my favorite teacher, or the street I grew up on, or my first date? What harm can that do?’ (Not realizing these are common answers to security questions) or ‘Why not talk about my big vacation coming up?’ (Not realizing they’re letting thieves know when their house is going to be vacant) People reveal information about themselves all the time online without a second thought because they can’t personally see the danger. I can’t personally see a problem with using my domain in this way, but I would prefer to check with those more experienced than me before I learn the hard way that I made a bad choice. I do appreciate you all taking your time to contribute your thoughts.

    10