Re: [fpc-other] PostgreSQL index tuning
On 25/09/2021 16:00, Graeme Geldenhuys via fpc-other wrote: Hi, Does anybody know if there is a tool I could use to analyse queries to a PostgreSQL database, so I could tune it's performance. eg: detect table scans in the execution plan, suggest creating, dropping or altering indexes etc. MS SQL server comes with loads of tools and options to do this, but I'm fairly new to using PostgreSQL as the data store, so not sure what tools are out there. Any suggestions would me much appreciated. For individual queries https://www.postgresql.org/docs/current/using-explain.html To watch a running server (via logfile) https://www.postgresql.org/docs/current/auto-explain.html and I think pgAdmin has some nice visualization https://www.pgadmin.org/ https://www.pgadmin.org/screenshots/#10 ___ fpc-other maillist - fpc-other@lists.freepascal.org https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] How to modify install scripts when svn disappeared?
On 11/08/2021 14:36, Bo Berglund via fpc-other wrote: I have for many years now been using an install script to get the sources of fpc and lazarus via svn based on the specific tags. Then the script installs the needed dependencies and makes the complete installation on Raspberry Pi boxes. Now I have two problems: 1) The svn server seems to be down so the source retrieval does not work 2) I cannot find any tutorial on how to proceed with modifications of scripts to move from svn to gitlab. Please advice how to: 1) Find which is the latest release tag of fpc and lazarus Well I don't know your script, and I am not sure how exactly you do that in svn Also I do not know, if this is for a once up setup (so you only wont to download the one revision and nothing else), or if you don't mind. (I have not measured the overhead..>) Most replies will be to clone all, and then look at tags. (or branches) But you can do ( -t => tags) https://git-scm.com/docs/git-ls-remote.html git ls-remote -t https://gitlab.com/freepascal.org/lazarus/lazarus.git However, there is on "svn serial rev number", nor a date. So you need to parse the "release version" number, and compare them. If you have a complete clone, you can afaik sort them by "commit date" (see "git for-each-ref") 2) Retrieve the full sources for that tag on the command line Again if you do not want to clone git init . git fetch --depth=1 https://gitlab.com/freepascal.org/lazarus/lazarus.git refs/tags/lazarus_2_2_0_RC1 git switch -c my-branch FETCH_HEAD "my-branch" is your choice *** the rest BELOW is completely UNTESTED / pure assumptions *** I haven't tested how well updates work, if you go to other branches. Since you have no history fetched (depth =1), I expect a full download of any other version (unless it is a direct child / same branch, NOT diverged) Git is written for getting the full history once. I *guess* (but might be totally wrong) that not doing so, will make you pay later. You could do a depth of 3000 or 1. That is 2.2.0 (with the ending 0) is likely less that 3000 commits divirged from main. Then that gives you common history, and 2.4 can base on that. 2.0.18 is probably more revisions from main. If you only want to stay in the same fixes branch (and are ok with a new download for major releases) go with a depth of 500. It is unlikely that a release tag will be further away from its fixes branch (usual are 0 to 5 commits) ___ fpc-other maillist - fpc-other@lists.freepascal.org https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] VSCode
On 26/04/2020 14:21, Sven Barth via fpc-other wrote: Am 26.04.2020 um 14:03 schrieb Martin: Just curiosity: I recently see a lot of great efforts to make things more widely available (language server / debug adapter). Often with reference to use in VSCode. I wonder what the advantage or usecases are for using VSCode as an IDE? - free and open source - cross platform - easy to setup - support for a wide range of languages (syntax highlighting, the language servers) and environments (e.g. there's Arduino support which is leagues better than that of the Arduino IDE) - if the language server is implemented well then good code completion as well So matter of taste? Same as some people prefer eclipse? I was wondering how it compares (if used with FPC) to Lazarus. (Not saying that Lazarus has a monopoly, just interested in knowing the diffs) I.e., maybe it offers some features that Lazarus does not have? I can see the advantage for people often using diff languages, to use one IDE for all of them. ___ fpc-other maillist - fpc-other@lists.freepascal.org https://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] Git & SVN
On 23/05/2017 16:04, Graeme Geldenhuys wrote: WTF? Branching and Merging are two key feature of Git. So if the don't want merging (or only allow fast-forward merges), I guess they want to Rebase everything everybody contributes - yeah the lovely linear history of SubVersion because they don't know better. Or maybe they haven't forgotten how nice and simple svn is. Git just doesn't do KISS. --- (I use both git and svn, and both have things that I personally miss on the other) But at least this thread is highly amusing, so thanks for that ;) ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
On 16/03/2015 14:54, Graeme Geldenhuys wrote: Hello Martin, On 2015-03-16 14:35, Martin Frb wrote: A simple git alias can do that for you all in one command. ;-) And in a GUI? The only GUI on windows that was to my taste, is Tortoise. And exactly why I don't bother with 3rd party GUI frontends. They *all* lack git features. Well and there we are: For people who want/need/prioritize a GUI, GIT is (for no fault of its own) not always the best choice. ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
On 16/03/2015 14:18, Graeme Geldenhuys wrote: Hello Martin, On 2015-03-16 13:17, Martin Frb wrote: Local commits (commit, without push) can be a huge advantage. Ah yes, but they loved the idea shortly afterwards. As I said they *can* be a huge advantage. "svn up" is roughly equal to: stash, fetch and rebase (pull?), stash pop. A simple git alias can do that for you all in one command. ;-) And in a GUI? The only GUI on windows that was to my taste, is Tortoise. But if there is another GUI, that can do that? On win, ideally with explorer integration and not custom drawn (its on windows, its hould look (aprox) like a win app) True it is not the fault of GIT, if there is on frontend that suits me But it does not help This is, if I want to update, and just be left with any merge conflicts in by local changes. And that is why I trained them from the start to develop in local feature branches, and never directly in 'master' or 'develop' (any tracking branches). Follow that and you will never get a conflict on a 'git pull' again. In fact you don't need 'git pull' then, only 'git fetch' will suffice. Then when you have the time, you can review the latest changes from upstream (origin) and merge those into your local feature branch - when it suits you. And while all this has many advantage, it is not the point. Yes you can avoid (or defer) the merge conflicts. Which is again a good feature. Unless of course you are not interested in deferring them. ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
On 16/03/2015 12:53, Graeme Geldenhuys wrote: I fully understand that. I think the biggest resistance to migrating to git is the "distributed system" principle. That scares people. That is why I introduced the developers, at my previous employment, to git by simplifying things. I let them use a client/server workflow model. That seem to have helped them a lot, and get over that fear they had. Actually there are other things: Local commits (commit, without push) can be a huge advantage. But the act that you need twice the commands to get your commit to the server can also be a turn off (Command line you can use a script / but with a GUI...). Same for update. "svn up" is roughly equal to: stash, fetch and rebase (pull?), stash pop. This is, if I want to update, and just be left with any merge conflicts in by local changes. Sure Git offers me tons of choices here, and sometimes they are useful. But if I just want the equivalent of "svn up", then git is more work. ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
On 16/03/2015 09:23, Graeme Geldenhuys wrote: "As the majority of developers would tell you, Git is simply the better product at this stage". That I can live with. There is a 2nd potential point of confusion to it. "better product", simply means: Compared to others it scores better on more use cases. It does no mean (at least not to me), that it is better for *all* (or very high percentage [1]) use cases. I did myself mix that up in my previous reply. [1] This in not to say, it could not be a high percentage, it just says that the phrase does not necessarily mean this. For example (assuming you use a provider, and do not have to set up the server). The learning curve for an absolute newly is higher for GIT than far SVN. Different people learn in different ways. There will be a fair share of people for whom taking their first steps into using a repository is better done with a simpler system. (Just for the learning, but it still is a valid use case) ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
On 16/03/2015 09:02, Graeme Geldenhuys wrote: Hello Martin, On 2015-03-15 20:32, Martin Frb wrote: But that does not change, that there are developers who store their projects in GIT, but who do not use the features at all. For such a developer it can be said, that even CVS has more feature, than the set of features they use in GIT. This is one case, where GIT was clearly not the best choice. (Assuming they had choice) There is no rule that says you must use all feature of Git, otherwise it is waisted or not the best choice. Again: Not what I wrote. In fact I wrote: I (myself, as an example) am using GIT, yet I am sure that it still has much for me to discover. But just because in my case that is still making at a good choice (in specific cases, the best within the range of choices I know), does not mean that this is the same in every case. As for what you wrote. Yes there is no such rule. But the absence of such a rule, does *not* mean the absence of such cases. Not every case where GIT is not fully used, is a waste. But such case do exist none the less. ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
On 15/03/2015 20:32, Martin Frb wrote: I'm not talking about just installing it and not doing anything with it - that's NOT using a product, so you can't review it based on that. I forget that in my reply: That is what some people do (and what I pointed out): install, but not really use. I did *not* judge GIT on that. I did judge your statement on it, that /As 99% of developers would tell you, Git is simply// the better product./ 1) How would those none users even judge that, what value would there statement have. 2) Should they really be told that GIT was best for them? If they do not want/care to use all the features. If for example all they want is an online backup, with access to all previous backups (revisions): Should I tell them GIT is the best product for that task? I am willing to believe that 99% of the developers you know / you have asked say that (and even that, when they said it, it was correct in the situation.) But "the developers you know / you have asked" are not a random selected group, they are not representative of *all* developers. If you state the above, without clarification of what group of developers, in oher word, if you refer to *all* developers then I disagree. So I am convinced that: - either a lesser percentage does say so - they are giving bad advice (telling someone to use git, who would be better off without) ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
Reading the replies I can clearly see that neither of you have ever used Git for actual work. I have, and I do. That said, only for maybe 6 to 9 month by now, and in that time I might well only have scratched the surface of it, and yet much to discover. But never mind how well I know it, that was never the point. I did at *no* time say that git was not good, or could not be useful. I said that, it is not always the best choice, for that: read on below: I'm not talking about just installing it and not doing anything with it - that's NOT using a product, so you can't review it based on that. >>/ Look around. I have seen many git repositories (svn probably too), where />>/ the (sole) committer uses git in a way, that cvs would allow to do more. />>/ How is git better for them? / Your statement is so ridiculous I had to laugh out loud. Git is magnitudes better that CVS and SubVersion combined. And yes it is extremely useful even for a sole developer. That has nothing to do with what I wrote. And I never said that this was not the case. Yes it *can* be very useful for a single developer. But that does not change, that there are developers who store their projects in GIT, but who do not use the features at all. For such a developer it can be said, that even CVS has more feature, than the set of features they use in GIT. This is one case, where GIT was clearly not the best choice. (Assuming they had choice) It is not about what GIT can do, but what a developer makes out of it. And also what a developer actually wants or needs. then please stop spreading FUD Read what I wrote, before falsely accusing me of spreading FUD. if you actually tried git, you would soon realise it is a vital tool I tried it, not only did I try it, I use it for some projects. I still stand by the statement that I made. I regard Git just as important as a good programmer editor or IDE. Yes, that important! I agree, yet there are many IDEs, and for different tasks different IDE are better suited ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
Reading the replies I can clearly see that neither of you have ever used Git for actual work. I have, and I do. That said, only for maybe 6 to 9 month by now, and in that time I might well only have scratched the surface of it, and yet much to discover. But never mind how well I know it, that was never the point. I did at *no* time say that git was not good, or could not be useful. I said that, it is not always the best choice, for that: read on below: I'm not talking about just installing it and not doing anything with it - that's NOT using a product, so you can't review it based on that. >>/ Look around. I have seen many git repositories (svn probably too), where />>/ the (sole) committer uses git in a way, that cvs would allow to do more. />>/ How is git better for them? / Your statement is so ridiculous I had to laugh out loud. Git is magnitudes better that CVS and SubVersion combined. And yes it is extremely useful even for a sole developer. That has nothing to do with what I wrote. And I never said that this was not the case. Yes it *can* be very useful for a single developer. But that does not change, that there are developers who store their projects in GIT, but who do not use the features at all. For such a developer it can be said, that even CVS has more feature, than the set of features they use in GIT. This is one case, where GIT was clearly not the best choice. (Assuming they had choice) It is not about what GIT can do, but what a developer makes out of it. And also what a developer actually wants or needs. then please stop spreading FUD Read what I wrote, before falsely accusing me of spreading FUD. if you actually tried git, you would soon realise it is a vital tool I tried it, not only did I try it, I use it for some projects. I still stand by the statement that I made. I regard Git just as important as a good programmer editor or IDE. Yes, that important! I agree, yet there are many IDEs, and for different tasks different IDE are better suited ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other
Re: [fpc-other] [fpc-pascal] Google Code closing down
On 14/03/2015 11:45, Graeme Geldenhuys wrote: On 2015-03-14 11:38, Mark Morgan Lloyd wrote: [Sigh] I feel like I'm being pushed onto git rather than Subversion. Then don't resist it. As 99% of developers would tell you, Git is simply the better product. [Graeme runs and hides :-P] If more features equals better ... Moth fly into the light, not because it is better, but because it is shiny. And a sledge hammer is not the best tool to drive a nail into your wall. Look around. I have seen many git repositories (svn probably too), where the (sole) committer uses git in a way, that cvs would allow to do more. How is git better for them? This may still leave git the better choice for many (maybe even a majority). But 99% ? Also one should make such decisions based on what is needed. Not what others do. ___ fpc-other maillist - fpc-other@lists.freepascal.org http://lists.freepascal.org/cgi-bin/mailman/listinfo/fpc-other