Struggling with SQLite in Java console app under VSCode

[[)roi(]]

No issues with compiling and running from the console, the issue is compiling and debugging in VSCode (the app itself is a console app)which happens to have a nicer UI and is snappier than Netbeans. I’m back to Netbeans for now. All I really need to do with VSCode is get it to recognize my own added class libraries. In Netbeans I can just import the file. VS code probably had that issue hidden somewhere.

As for SQLite vs anything else, it’s generally pretty simple, not much to write ito connectivity code so that point is moot as you pointed out. It’s just a configuration file with 3 tables but around 1000 elements hence the need for sql rather than json or xml (bleah).

It's usually just a matter of default configuration settings for the compiler + most oif these affordances are available for download in Sublime Text as plugins, and I'd imagine much the same is available for VSCode. As for dependencies, I maintain standard template folder formats including config that is based on current folder offset paths, so the compiler configurations once setup just work.

 

[zippy]

Whats the specs on those machines? Will it run smoothly on a Pentium with 4GB of RAM alongside an instance of Chrome with 10+ tabs?

I can’t remember when I owned a machine with such low ram. My Mac mini has 8., windows pc and MacBook Pro has 16g. 8gig should fine for single instance debugging using netbeans, eclipse or IntelliJ. At work we use 32gig laptops, but that’s because we need be to running 3 jetty instances each with their dB backend, all locally.

4gig is good reason to use vi or notepad

 

[[)roi(]]

I'm giving Sublime a go. I really like it, have been using it for HTML / JS / CSS / PHP. Looks like I can get Java debugging going in it too.

Java support works well btw, and aside from what you mentioned I also use it also for C, C#, C++, F#, Haskell, Kotlin, Rust, Scala, Swift, etc...

Suggest you google guides on the text editing capabilities; it far exceeds IDE features in that regard; coupled with the plugins it's a veritable powerhouse disguised under a very simple looking UI.

For example:

• A Playlist of Sublime Text editing features

 

[Johnatan56]

VS code has those features, and I think better.
I basically use my IDE to mess with bullet point lists in it because it's nicer than using word, lol.
Duplicate up/down use shift+alt+up/down
Ctrl+alt+up/down for cursor trick,
alt+click in places you want your cursor, multiple areas.
Do note I remapped some stuff, so could be mine is different, can't remember what was different from default. There are a lot of addons that bring keybindings of other programs into VS Code, IntelliJ has the same.

I don't bother to remember some of the shorcuts, e.g. combine line. Just F1/Ctrl+shift+p and hit join line.

Again, pretty much all IDE can do all of those.
Sublime doesn't seem to have Emmet? https://github.com/sergeche/emmet-sublime as addon required. Highly recommend if you need to mess with html.

 

[[)roi(]]

Sublime doesn't seem to have Emmet? https://github.com/sergeche/emmet-sublime as addon required. Highly recommend if you need to mess with html.

Of course it has emmet. Keep in mind VSCode came after Sublime Text, so most of the features in VSCode were inspired by Sublime Text, and other editors.

Ps. re videos; that was just a quick introduction; far more features are available of course. Second biggest difference is performance; VScode being an electron app is hardly to be considered memory efficient or very performant solution; especially sucks with large files.

 

[Johnatan56]

Of course it has emmet. Keep in mind VSCode came after Sublime Text, so most of the features in VSCode were inspired by Sublime Text, and other editors.

Ps. re videos; that was just a quick introduction; far more features are available of course. Second biggest difference is performance; VScode being an electron app is hardly to be considered memory efficient or very performant solution; especially sucks with large files.

I know it is, but it's amazing what happens when devs actually don't bloat it to insanity.
I've never had VS Code hang, not even on 4GB machines with hundreds of files open without noticeable lag.

On this machine I am right now skipping randomly through files that include plugins that highlight stuff, e.g. beautify 2, and yet everything opens instantly, this over 40 random files with 100 lines or even the minified file that's about 8000 characters in one line, scrolling sideways through that has no lag.

And yes, it does use more RAM than e.g. sublime, but if I don't experience slowdowns and the features improve my experience, then I don't really mind.
Currently with those files mentioned open, I am using 870MB of RAM and 0.5-1.5% with spikes to 4% of CPU, of that RAM usage, 200MB is the PHP CLI.

If I seriously needed the performance, I can go to notepad++

The reason I don't like Electron is that most app developers just don't know what they're doing and bloat the things to insanity, slack is a great example. Of course I'd prefer if VS Code was native, but I don't notice any performance reasons to switch, even on a slow 5400 RPM HDD it's still fast enough, yes, boot times are about 3-4 seconds versus sublime's ~1s, but that difference really doesn't matter overall.

https://www.sublimetext.com/blog/

Nice roadmap, must say Sublime 3 is a huge improvement on 2. I like the afterglow theme: https://packagecontrol.io/packages/Theme - Afterglow due to rectangular tabs, but that's personal preference.

For most it will also be easier to create plugins/addons in VS Code due to using web framework rather than python, but again, most of the plugins you'd use will be there and you only "need" (want) a handful of them.

Again, the discussion of IDE is subjective for most. I like a lot of different IDEs depending on what I am doing, the only IDE I truly dislike is Eclipse due to being affected by some bugs while using it.

As a side note, really do install live share on VS Code, you can use your own keybindings while remoting to the other person.